I have a workbook with multiple sheets each representing a different day of
the month and containg data relating to the days sales in columns of
locations and amounts.
I want to create a summary sheet with locations down column a and dates
across row 1 and have to sales by location by day on one sheet.
Is there a way to lookup the sheets without having to change the sheet name
in each formula?