I have worksheets labeled from C1 to C13. The titles of the worksheets are in cells A1 of each worksheet. I want to create an index worksheet with the format of the worksheet in column A and the values of each of the respective contents of A1 in column B of the index worksheet. I have listed the worksheet names - from C1 to C13, and concatenated a string in column B to read C1!A1, C2!A1, etc. How do I get the actual value to show up on the index worksheet?

Perhaps try the INDIRECT function

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post