Count data in cells over multiple tabs

[Add365]

Hi Everyone,

Can anyone help I have an excel file we use at work which has tabs at the bottom for the months of the year and each tab has data of Job ref's and profits etc, I am trying to work out a way to pull the data automatically from all the tabs so I can see it in a second tab. I would like to see how many job entries have been entered per day/week/month by each person (job Creator) with the running totals on revenue (profit made).

I have tried it with a pivot table but I keep getting errors and it only updates when I close the file down. Is there formuals that will work it out automatically?

 

[Add365]

Hi all,
So far I have worked out how to see how many entries have been made by who per week/month/etc, but I cant work out how I can get a running total on profits (column H) based on the job creator and date the jobs was entered. Below is a screenshot and the formula I have used so far.

CREATOR	DH	Creator	DH	Creator	DH	Creator	DH
START DATE	01/03/2022​	START DATE	01/03/2022​	START DATE	01/03/2022​	START DATE	01/03/2022​
END DATE	07/03/2022​	END DATE	14/03/2022​	END DATE	21/03/2022​	END DATE	31/03/2022​
DH TOTAL ENTRIES	5​		6​		16​		20​

=SUMPRODUCT(--('March 2022'!$A$2:$A$2000>=$G$4), --('March 2022'!$A$2:$A$2000<=$G$5), --('March 2022'!$D$2:$D$2000=$G$3))