Hi,

I am new to VBA, and am trying to figure out how best to perform this procedure.

I have 30 files that are sent to me weekly from different users i.e. (file) 1 (attached). The file contains 3 worksheets, all of which will be filled up by the users. I am to pull data from each worksheets and display them according to date i.e. Sample 2. So, I've been copying data from each workbook and input it into the master workbook.

I have been reading up on various Excel functions e.g. Consolidate, Pivot table, Merge but have yet to find an answer.

Is there an easier solution to this problem?

Thank you for any help provided.

Sample2.xls1.xls