I have the sheet name linked to a cell in each sheet, and the top row of my table is pulling that same cell. Now I want to be able to link all the columns in my table to that top row, instead of listing 'Sheet1'E11, 'Sheet2'E11, etc in all of the cells below. This is a large table, and will need to be sorted - would be much easier to handle if on the top row needed to be sorted and all other cells would recalculate...

Show us what you're referring to by posting a desensitized sample workbook. Then ask your question a little more clearly, I'm not getting your query.

Click GO ADVANCED and use the paperclip icon to post up a desensitized copy of your workbook.

I found my answer in a different thread. My need was to use include the worksheet name in a formula by referencing a cell, not typing out the entire sheet name in every cell.

Here is the link to the answer I found:
http://en.allexperts.com/q/Excel-1059/worksheet-name-formula.htm