Forum Discussion
Summary Sheet with multiple different tabs with different information
I have a summary sheet I need to make. It goes through multiple sheets with different data. This is the blank Summary now, the pastel highlighted cells are the ones I need filled with data in mu...
They don't stay in the same spot. Each tab is a different flavour & some flavours have more ingredients so they may take extra rows. I need all Flavour 1 in the flavour 1 summary, flavour 2 in the flavour 2 summary, etc. but we might do 3-4 flavours a month (1 per day) & each day is a different tab. there could be up to 15-20 tabs a month.
How about merge all tables to one master table and then sum up?