i have about 30 worksheets with 18 columns each and varying numbers of rows
that i need to consolidate into one worksheet in order to pivot off the data.
each worksheet has a total row that i do not need to consolidate.

i have attempted to pivot off multiple spreadsheets and couldnt get it to
function properly.

i have also attempted consolidating but the result is not what i
need...short of copying and pasting is there a simple way to consolidate the
data? thank you.