I have a project that requires me to copy mutiple worksheets to one hub
worksheet. Is there a way to make the worksheet name a variable?
This is what i have so far:

=IF(Period8224a!$R$9=$C$2,Period8224a!$N$9,0)

The Period8224a name will change like 50 to 100 times. If there was a way
to reference the name of the sheet from a cell on the hub sheet like this:

=IF("X1"!$R$9=$C$2,"X1"!$N$9,0)

with the "X1" cell containing the worksheet name.