Hi Jen (in Quality Control?),
My brain gets like that too (and too often). See the attached where I've used an Indirect Address combination. The address function takes the last parameter/argument as the sheet name which makes this work.
Indirect Address using Sheet argument.xlsx
Bookmarks