Summing multiple tabs

[peterg97]

Hi All, 

I am trying to sum multiple tabs into one tab (I've attached some sample data to give you an idea of what I mean). Each of the tabs have the same layout, but I need the figures from each tab to sum together, so that I can get the total figure for the week. I assume that the start would be to import as sheet names, but not sure where to take it from there, so any help would be appreciated!

Cheers, 

Peter. 

[afv2688]

Hello @peterg97 ,

does this look ok to you? 🙂

Regards

[peterg97]

Hi @afv2688, 

Thanks for helping out! I hope you don't mind, but it's actually a bit more complicated than that, so any further help would be great! I've attached an updated excel file with a few more complications. Basically I only want to sum the tabs with (Overtime). What I have done for this is input as list of sheet names and then filter for contains 'Overtime' so i'm good up until it comes to the stage after the formula where it creates the full file path. Its the stage after that that i'm struggling with. 

No problem if you can't take it any further, really appreciate the help up to this stage, its been useful!

Thanks, 

Peter. 

[Qiu]

@peterg97 

Just a thought.

[afv2688]

Hello @peterg97 ,

I think this time I managed to get what you want. This time it also does something else, if you add or there are some more columns added in the future the workflow will be able to add them automatically due the transpose tools 🙂

Regards