How to combine multiple workbooks into one worksheet?

Hello everyone,

This may fall under the VBA topic but I'm not sure. Here is the scenario:

I recieve 6 emails a day in Outlook that have the same format and layout with the same headers. The only thing that is different about them is the Unit name starting in A2, and their net revenue permonth listed in F2-T2. Currently Im having to save each of the six files i get daily into an existing file i have saved for each. This is time consuming. I was wondering if there was a way to combine all six workbooks into one WORKSHEET since they all have the same format and headers. I have attatched a dummy file that would look like one of the six files that comes in. I would appreciate any help that anybody has to offer. Thank you.