Hello!
I have a workbook with multiple work sheets, each sheet has an unique name and the names have spaces.
I'm referencing these sheets from a summary sheet that has totals, no calculations are needed. I need help on the syntax in the following formula;

=INDIRECT($B4&"!G"&TEXT($A4,"###"))
I understand that I need Quotes...just not sure where to place them.