Copy databodyrange and add to end of table (if/else)

The goal I am trying to reach is to copy the data in Table11 (varies in number of rows) and insert it as values at the end of another table.

Depending on the value of Sheet1!G9 (either 001.001, 001.002, 002.001, 002.002, 003.001, 003.002) it will either get pasted in sheet '001.001', '001.002', etc.

'001.001' has 'Table 5' '001.002' has 'Table 6' '002.001' has 'Table 7' '002.002' has 'Table 8' '003.001' has 'Table 9' '003.002' has 'Table 10'

Is there a way to do this?