@Karen
It makes things easier for helpers when one provides some data and manually mocked-up results to his sheet
Why not use one sheet instead of the three first, just adding a column with their respective origin ? From there a simple Pivot Table would be the way to go.

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post