wanting to reference the same cell in different worksheets

[jmzis4me]

hello,

please help. I've done this before a long time ago and I completely forget how I did it!

I have a calculation template that is the same for 10 different sheets. Just what I am calculating/the outcome changes per each sheet.

What I'm doing is setting up a summary sheet and instead of going through all of them and referencing each sheet/cell a million times, I just want to basically reference one cell in the summary worksheet that I type in the tab name and put the cell.

In other words, on sheet1, sheet2 and sheet3 I want to reference cell A3. So what I want to do is on the Summary tab, have reference cell, we'll say B2 and put in a 'Summary' tab cell something like:

="'"&B2&"!'"&A3

and in cell B2 put in Sheet1 or Sheet2 etc.

Thanks!!

[jmzis4me]

p.s. I know I flipped the ' and the ! up there, but that was a typo in here, not my issue in excel

[FDibbins]

Hi and welcome to the forum

you need to use INDIRECT() for this. Maybe...
=INDIRECT("'"&B2&"'!A3")

[jmzis4me]

that's what I was forgetting! I knew it was something simple like that, but it had been so long I forgot about Indirect.

Thanks for the help and the quick response!

[FDibbins]

you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)