I have a report that is completed by my team and sent to me each day by each member. I've standardized the way the emails are sent to me using another macro.
  • The spreadsheet they send to me is copied into the body of the email.
  • The subject of the email is "xEscalate"
  • The emails are sent to the folder "xEscalate" in Outlook
  • The report format is exactly the same except for the number of rows


I'm looking for a macro I can place in a workbook that will import the reports received today. I'd like the imported tables to be on the same sheet, so each emailed table is copied just below the previous, making one large sheet. Is this possible? I can also have the reports sent as excel attachments if that's easier to work with.

I'll attach a sample of one of the reports I'd receive. Thanks for any help!

SampleReport.xlsx