Hi- I am looking for some help in creating a macro that will import data from an XLS expense report into a master XLS. The goal is to import individual expense data into a master column format. This is done on a weekly basis and the file names change weekly, the file name format is <user initials><date>.xls Fils to import can be 10-20 at a time.

I have attached the Master file (where all the data is collected and saved, Macro should reside here)
Attached 2 expense reports. You will notice under Out of Pocket Expense section the fields listed can be different from expense report to expense report.




BH052512.xls
JJ052512.xls
Time and Expense Master.xlsm