I am wanting cell C20 to use the text in cell B20 as the name of the
worksheet to get the data from in cell Q4.

A thousand thank-yous to the first person to help.