I have an excel file with 32 sheets. The first sheet is a summary page. On the summary page I would like cells A1:A10 to display what is in cell A1 on sheets 2 through 11.
Example of summary page
A1 = A1 on sheet 2
A2 = A1 on sheet 3
A3 = A1 on sheet 4
and so on
Is there a formula I can enter in cell A1 and drag down to A10??
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.