Consolidate multiple workbooks, multiple ranges.

[FROGGER24]

I have a master file called BTRF AIIV.xls with worksheet called BTRF Listing in columns 1-18 starting in row 4 I would like to copy data from multiple workbooks with various variable length row. Starting in row 2 would like to copy from worksheet invhis to BTRF Listing. this code will be used by multiple users so I think all the workbooks will be open to run the code on

From columns to columns
The "from" columns start in row 2 and last row will be defined by column A
the "To" columns will start in row 4
20 to 1, 10 to 2, 22 to 6, 21 to 7, 28 to 9, 27 to 10, 32 to 12, 21 to 14, 23 to 15, and 1 to 18

Thanks for any assistance provided