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.