Paul, I am able to successfully run the macro! Thank you very much. It works great!

In my real situation, I have cells A3:AH3 populated in each tab for each project. Can you update the VBA code to take the data from row 3 (for project 1) in the source file and have it in row 2 in the master? Data for project 2 will come from cells A3:AH3 in the source file (Project 2 sheet) and needs to be on row 3 of the master tab. and etc for X projects. The number of project will grow over time... I hope this makes sense. Please let me know.

Jeff