4 Restaurants with each one Excel file containing 12 tabs for each month. Each restaurant lists its events in the correct monthly tab with details Date Location Amount of Guests Name of Event/Guest. The Tabs for each file and tab vary in row size as more events cause more rows, the columns stay the same.
I need a summary overview (no need to edit jut read only) for all 4 Restaurants. Preferably one tab per month listing all the 4 restaurants next to each other so I get an overview of all events taking place the same day and month. OK to adjust the layout of the file if that will help. Enclosed on file of one restaurant (name of events and clients name deleted) Looking forward to some great solutions. Thank you.