Referencing multiple sheets in one...

[vlcann]

I am currently referencing data from 20 different sheets (11 columns each, varying amount of rows) all on one sheet. I intend to edit random data on each individual sheet with the added possibility that I will be adding or deleting rows....

So my question is, how can I set up this consolidated sheet so that when I delete/add a column in the referenced sheets, it will automatically add or delete these (additional) rows?

I have it set to the range of rows that I currently have, but all together I have about 1500 rows and I do not want to go through all of these rows deleting anything blank or adding in more. This consolidated data also is also filtered so finding out where to add to any ranges would be difficult unless I wanted to "un-filter" them (which I do not). Any help would be greatly appreciated.

[k64]

Post a sample workbook to show what you're talking about.