Im trying to target a cell to get the name of a sheet in order to target a value contained within the other sheet.
I had a look at indirect but could get it to work.

Sorry, bit wordy I know. Hope someone can help.

Matt