Automating moving column data from one workbook to another specific column.

Hi I have been searching around, but I can't seem to find a solution that fits my needs.

I have a workbook that has unique columns of data that always has the same format. I need to move said data to another workbook that requires that data to be entered into specific columns and multiple times.

EX: Column A in Sheet1 of Workbook Cat needs to be in Columns G and Z of Sheet1 of Workbook Dog.

There is also a second workbook that follows a similar format that I would like to be able to do this with too.

testsheet is from where the data will be extracted starting form row 3, the other 2 are the destination workbooks.

Or alternatively use the source worksheet to generate the other 2 including the blank columns.