VBA to open, copy data from one workbook to another

[riteoh]

Hello,

Having only very limited knowledge of VBA, I am not sure if the below can be achieved or not.

I have a series of about 50 workbooks, each with 2 sheets in them. I need to copy the data from some of the cells in each workbook to a 'Master' workbook (with relevant cell headings), save the master workbook, then copy the next set of data to the next line. So in essence I am creating a table of data from each of the workbooks.

All workbooks would be saved in the same directory (e.g. c:\Workbooks\workbook1.xlsx) and all data is in the same cells, with each sheet having the same name. So I might need to copy Cells a2, a4, a6, a8, a20, a24 from Sheet labelled "Datasheet".

Can anybody give me help with this - I really don't know where to start!

Thanks in anticipation.

[Tinbendr]

See if you can find what you need here.