VBA Copying values from multiple files, pasting into one master workbook

[Tom07789]

I wish to copy data from a from a multiple of workbooks located within a specified folder.

Each file has data in cells C1, C2, C3, G1, G2, G3

This data needs to be copied into cells A2:F2

I then need to copy data from row A7:J7, to the last row of data located in column A

The data in A2:F2 will then need to be copied down to the last row of data currently available.

This will need to be looped opening the next work book within the specified folder, copying the data onto the next available row.

All pastes will need to be values only.

 

[cpatel13]

I wish to copy data from a from a multiple of workbooks located within a specified folder.

Each file has data in cells C1, C2, C3, G1, G2, G3

This data needs to be copied into cells A2:F2

I then need to copy data from row A7:J7, to the last row of data located in column A

The data in A2:F2 will then need to be copied down to the last row of data currently available.

This will need to be looped opening the next work book within the specified folder, copying the data onto the next available row.

All pastes will need to be values only.

Tom could you give more information, on the following
1) the copied data needs to be copied into cells A2:F2, in the same workbook from which it had been copied or to a new master workbook?
2) from where you need the data be copied A7:J7 and which file it needs to be pasted?

Please be more clear to exactly what are your requirements, and if possible provide a sample file.