Macro to transfer all data from one workbook to a specific sheet in another workbook

[brad999]

Evening all! I have limited VB skiils and been looking for a macro described in the title but have not seen any that fit my needs.

Basically I have data in 2 different workbooks as attached, and I need to transfer all data in 'Jx_ex1' to sheet1 in the 'template' workbook, and all data in 'Gr_ex1' to sheet2 in 'template' workbook. The data must be transferred to the same cell numbers as the original data is in. I actually have loads of workbooks to transfer to the template but if I have an example with the two then im sure I can work out how to modify it. The template has the data in it how I want it to look after running the macro.

Any help would be greatly appreciated! Thanks in advance.

[alansidman]

In the template in Sheet1, row1 is blank and in Sheet2, rows 1-8 are blank. Is this the case in your actual template. Would it cause disharmony if the sheet1 of each of the files was copied in to the template? or will it be necessary to map the data to specific ranges? This is an important question as to how the data is transferred. Are all the workbooks to be transferred located in the same folder? Are there any files in the folder that should not be transferred.

[brad999]

Thanks for the reply, yes that is the case in the template with row 1 being blank on sheet 1, and rows 1-8 in sheet 2. It doesn't really matter as long as it is consistent between 'ja' and consistent between 'gr' files. All data should be transferred rather than specific ranges.
All workbooks are in the same folder and all workbooks in that folder should be transferred, with each workbook being sent to a specific sheet name within the template. Does that help? Thanks alansidman!

[brad999]

Can anyone help? I'm sure someone clever who can transfer data to 1 sheet knows how to transfer data to multiple specific sheets