Running total summing different tabs

[Big Dingo]

Hi,

i would like a formula that will sum all of the data relating to the counterparty column entries across all tabs. I plan to paste the data into the relevant tabs daily and would like the running total tab to populate automatically. So basically for all Bank Of America it should tally all of the USD volume, USD markup and MS fees for each day of the month. I hope this is not too difficult.

Thanks in advance. My spreadsheet is attached
ECN running totals template.xlsm

[oeldere]

See if this is what your up to.

add new data and

Run macro Sub AddAllDataOnTheFirstSheet()

The pivot table will automatic refresh.