Using that method, you must "know" the name of the worksheet. If you are going to get some variable worksheet value, use that method to get the value from a "known" worksheet name and cell first.

That method will fail if the worksheet name does not exist. Not all workbooks have a Sheet1.