Consolidate Data from Multiple Files (Different File Names) into a Master File

Hi All,

Being new to the world of macros and VBA, seek guidance here.

There are multiple workbooks (one for each user saved at the same location/folder) with 5 worksheets within the workbook each. Data is entered by users into their respective workbook under various columns. This data needs to be then updated onto a Masterfile in the manner that:
1. Data for each respective worksheet gets copied into the same worksheet on the Masterfile.
2. Data from each of the users' sheets is copied one over other and then sorted chronologically per date of entry.
3. In case of any 'blank' row of information, the macro over-runs this row to reflect only 'filled' rows of information on the Masterfile.
4. Information from users' workbooks be updated only when the file has been saved.

Can we also have a macro-driven 'Refresh' option that helps refresh the data for any reference?

Let me know should there be requirement for a sample worksheet.

Thanks.
Praveen

Hi Praveen,

welcome to the world of Macro's.

could u plz provide sample worksheet its more helpful to resolve.

Thanks - Naveed.

Tracker_MASTERFILE.xls.xlsxTracker_User1.xlsHi Naveed,

Thanks for the prompt response. Please find sample Tracker_User1 that one of the users would updated, and Tracker_Masterfile that needs to pull data from Tracker_User1, Tracker_User2 and more.

Thanks.

Hi Praveen,

in Tracker user1 have 7 tabs this all 7tabs data need to combine in master file in respective tabs.

One more thing in that there is no data if possible add some data to that worksheets.

Thanks - Naveed.

Hi Naveed,

Please find attached the updated sample file for your reference. The data can be anything so you can enter any data to test-run the macro.
Thanks.

Hello Praveen, Are these headers same in all the sheets. Worksheet Process 5 repeats header info15 to info20 in column U to Z.
Thanks/VKS

Yes. Thanks.

Im following that topic because ı need such macro so that ı can copy data from files into a masterfile.

Originally Posted by jeffreybrown

Welcome to the Forum etandogan, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

Sorry for that, thanks for your warning.