Transferring data into separate work books [Closed]


I was hoping to get some advice on the best way to transfer data from one work book to another. Both works books are collecting the same data but they are storing the data in different columns/areas.

I am collecting a lot of data in one workbook/sheet, where as my friend is collecting the same data in multiple workbooks/sheets. The idea is to transfer his multiple sheets into my single sheet.

I have a lot of data to transfer into the correct cells from work book to work book and I was wondering what the most efficient means would be.

Any help would be reatly appreciated!

Many thanks,