I have workbook A, B, C, D etc in a folder...
each workbook has four sheets... sheet 1, sheet2 etc.
I want to combine the data from sheet1 of all workbooks into sheet1 of master workbook (which already exists) and similarly sheet2 etc.
The workbooks are from different users... they all have same headings.
Your help will be much appreciated.