How to get worksheet names to change to next worksheet

[Dawnheffley]

Hi,
I'm Dawn and am new to this forum. I have been using excel extensively for a few years and am trying to get a master sheet to pull information from various worksheets in the same book. The problem is that I want a different worksheet on each row but the same cell etc. I would like to be able to make the worksheet name change by cell A of that row. I have the sheet name listed in Column A. Is this a possibility, it seems like the answer is yes but I have not been able to get it to work. Any help would be greatly appreciated.

[PFDave]

please upload a sample workbook and we will have a look

[Dawnheffley]

Here is a sample worksheet

[ChemistB]

No worksheet. Go Advanced>Manage Attachments>"Choose File" > "Upload"
If you did that and it didn't work, maybe the workbook was too big. Try deleting all but a few rows of data (enough so we can get the jist of what you want).

[Dawnheffley]

OK, I think it is here now

[ChemistB]

Okay, In B4 for example

=INDIRECT("'"&A4 &"'!$C$5")
Note: that's a double quote followed by a single quote, then a double quote, then & A4 & then A double quote, single quote and !$C$5 double quote

Similarly in D4
=INDIRECT("'"&A4 &"'!" & E5)
Does that help?

[Dawnheffley]

Thank you, I had tried something similar but must have had too many quotes

[Dawnheffley]

Thank you, I had tried something similar but must have had too many quotes How do I mark solved?

[ChemistB]

Actually my second equation is incorrect I believe. Should be

=INDIRECT("'"&A4&"'!E"&ROW(E5))

How to mark solved? Go to first post and look for "Thread tools" dropdown to "Mark Thread solved"