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.