Thanks Excel Fox for both formula and code

The Indirect Function looks to be a very useful one.
How does this formula work especially the Indirect part.
Code:
(INDIRECT("'"&G5&"'!$D$4:$D$53")
Is this part referring to a sheet "'" ??
How does it know which sheet or can the sheet name also be placed in the formula?

Thank you

Paul