Using a value in a cell to display another cell
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?
|