Change Master Sheet Data by Date from multiple sheets

After further playing around, I think what I need to do is somehow include the INDIRECT function into a SUMIFS function, like this one - =SUMIFS('Site 1'!$B:$B,'Site 1'!$A:$A,A26)

Instead of entering 'Site 1', I want it to be able to read from the cell where the user can select which site.

All sorted. I knew if I looked at it long enough, I'd be able to do it.

Please find attached the solved spreadsheet where I combined both the SUMIFS and INDIRECT functions to create what I need.

There's probably an easier way to do it, but I'm happy to use this.

Cheers!