Indirect Function Returning #REF error

I'm sure this is going to turn out to be something simple that I am just not seeing, but I cannot for the life of me figure out how to rectify this error.

I have a large workbook that has separate tabs for each team member and I am needing to pull that data to a new sheet where all the team members can be seen side-by side. To make life easier, I would like for the sheet name to change dynamically when I copy/paste the formula for a new week so I am not needing to go in and change them all manually. I am attempting to use the Indirect function and am receiving a #REF error. I've attached an example with just one team member in the hopes that someone will be able to tell me where I am going wrong here.

This is what I have. I am wanting only the sheet names and the row number to change when I copy/paste the formula.

Thank you very much in advance for any assistance

Please Login or Register  to view this content.

Maybe something like this:

Formula:

Please Login or Register  to view this content.

You might need to tweak the absolute/relative references depending on what you are doing.

You're welcome. Thanks for the rep.