Hi everyone,
New here, but I did search the threads to see if my answer was on here somewhere, and I couldn't find something that worked for me. I've seen a lot of threads with the Indirect Function which I think I understand, but I keep getting the #REF! every time I've tried.
I need to pull values from the same cell on different sheets, and create a list on a Summary Sheet.
For example, I would like to pull cell F20 on all of my previous sheets (let's say Sheet 1 through Sheet 10) into Column D of "Summary Sheet". I'm looking for a formula I just drag from D3 to D13 to populate it.
Extra Question - Is there also a way for me to add sheets, and the summary sheet will also pick up on the added sheet, and insert the value into the Summary Sheet?
Many thanks in advance.
Bookmarks