Yes, you can do it using INDIRECT to form the sheet name and range,
assuming your names have some naming consistency. Perhaps if you post
back with actual details of cells/sheets used and how things are laid
out in your summary sheet, then we might be able to give you a formula
to achieve this.

Pete

On Sep 29, 5:27*pm, DMcCormack
wrote:
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?