AvantStay Financial Analyst interview questions

(sent an Excel attachment with these questions) The attached file contains five made up P&Ls for different cities. Using this information, please build out a dynamic consolidated P&L for all 5 cities in a way that allows us to: 1. Quickly filter by city or total consolidated company (i.e., shows all of the P&L categories, but sums up all of the city figures), 2. Shows performance by year, quarter and month, and 3. Allows for the ability to add more city P&L tabs with similarly formatted data into the file (e.g., City6, City7, etc.) that are automatically captured in the consolidated P&L.