Is it possible to subtotal over 100 spreadsheets in a workbook at one

Morning all, I have a workbook with over 100 tabs (all with same heading).

Is there a way to subtotal all tabs at once? I obviously want to perform the same exact subtotal for all but all spreadsheets have different number of lines.

I'm new on here and I've searched for the answer with no success.

HI skettler and welcome to the forum

are you saying that the layout of each worksheet is not the same? and if thats the case, is there any way to make them the same?

because if you can make the layout/format identical on each sheet, you can use this trick to very quickly summarize all sheets onto 1 "master"...

if you add a blank worksheet at the start and end of your data sheets, and call them Start and End, then when you enter your calcs, you could just enter =sum('start:End'!C12) or whatever your references are. this way, you can add or remove sheets as needed, and it will add across all the sheets you need it to, and keep the totals as the data sheets change. make sure your "Master" sheet is before the Start sheet though

ok, not sure I understand you then. any change of a dummy workbook, showing some sample data/sheets, and a few examples of what your expected outcome is, as well as how you arrived at that?

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

ok, i totally misunderstood what you had/wanted lol. it would be simple if they were all on 1 sheet, extracting unique entries if fairly easy

no, what I meant was it would be easier if ALL the data was ion 1 sheet, thats always better to work with

This what you want

Please Login or Register  to view this content.

Nope your not missing anything I thought you just wanted to subtotal the sheet, I must of missed the part by groups. Will column a be sorted already?

Run the macro integratie Oeldere.

Please Login or Register  to view this content.

You get the result on the sheet Consolidated

After that i made an pivot table of the data.

Please reply it this works for you.

How about this

Please Login or Register  to view this content.

Maybe you want something like this (subtotal per group).

It's all on the sheet consolidated.

See the attached file.