I can't seem to use the indirect function to lookup data in another sheet if
the sheet name contains a single quote.

Sheet1 - I have in cell A1: Sheet2!A1
In cell A2 I have: =INDIRECT(A1)

If I change the name of Sheet2 to Int'l and change the contents of A1 to
Int'l!A1

then it no longer works.

What can you do when the sheet name has a single quote? I am going to be
referencing data from a web site and I want the names of the sheets to be
able to be referenced just by the name of the data. I have no control over
this data and so it will have the ' in it.