I couldn't really figure out how to search the forums for this one...
sorry I just don't know the terms that would make a topic such as this
one show up for me.

My question is, (or is it even possible?) :

I am setting up a summary sheet of multiple worksheets and I'm making
multiple columns. Each column corresponds to a specific cell in each
worksheet I want to be able to drag down a column using the auto
increment feature and have it increment the worksheet so that column 1
row 1 has worksheet 1 cell 1 and column 1 row 2 has worksheet 2 cell 1
etc.

I'd just like an automatic way instead of having to change the
worksheet name each time.


--
Ethan
------------------------------------------------------------------------
Ethan's Profile: http://www.excelforum.com/member.php...o&userid=24534
View this thread: http://www.excelforum.com/showthread...hreadid=381267