I have set up a formula that returns the value from a cell in a particular sheet (call it Sheet1) to a master sheet (call it Master). The formula =Sheet1!D$1 is written in cell E3 of "Master". I would like cell E4 Master to have "Sheet2" instead of "Sheet1" and cell E5 Master to have "Sheet3" and so on. Is there a way to use the Auto Fill feature down col E (and other columns). Seems easy, but I am an excel novice so any help would be appreciated.
Bookmarks