Look at the INDIRECT function in XL Help.

Hope this helps.

Pete

"Ditch" wrote in message
...
Hi Team,

I'm wanting to (I think) use the Validation list tool to return sheet
references. I do not want to use macros.

I have multiple sheets all with the same row and column headings but with
specific company data in the cells.

i want to copy the sheet format such that the 'Selector' sheet can
reference
whichever tab with multiple cell references.

eg Instead of Sheet1!A5 Sheet1!B5 Sheet1!C5 etc.
Sheet1!A6 Sheet1!B6 Sheet1!C6

I want <SheetA5 <SheetB5 <SheetC5
<SheetA6 <SheetB6 <SheetC6

where the <Sheet can be selected from a drop down menu. This will allow
me
to drive graphs where the user can change the company they wish to view.

Thanks,
Ditch