Indirect Worksheet Reference

[gflory]

I have created a summary worksheet that includes data from 10 separate worksheets in the same workbook. I am looking for help with creating a formula that will allow me to copy and paste(relative) from separate worksheets to the summary worksheet.

For formula purposes, here are worksheets names

Separate worksheets:

A, B, C, D, E, F, G, H, I, J

Summary worksheet:

Z

Thanks,

 

[Robert Mika]

Do you want literally copy and paste -which you can do manualy or bring some data to the summary worksheet from the A-J.
In this case which data?

 

[robertannalee]

A little off the category.....but am hoping someone can help me "autofill" sheet names. I have created a annual inventory....and multiple worksheets. Would like to know if I can somehow.."autofill" the sheet names????
Thank you for any assistance

 

[T. Valko]

A little off the category.....but am hoping someone can help me "autofill" sheet names. I have created a annual inventory....and multiple worksheets. Would like to know if I can somehow.."autofill" the sheet names????
Thank you for any assistance

Here's one way...

http://www.mrexcel.com/forum/showpost.php?p=2118912&postcount=1