Formula required to filter data

[T4M]

My situation is this:

I need to report on 5 publications (26 in total) for the different UK local health authorities which I've found to filter by counties.

My spreadsheets are divided by members & month, non members, health professionals & agencies.

My information is all on different spreadsheets as I create them by month, how can I filter the data to find what number of publication was sent to that health authority without manually filtering the data by county?

Any advice is much appreciated. Pulling my hair out thinking of doing this massssively time consuming process...

Thanks

 

[Robert Mika]

Hi T4M and welcome to the board.
Could you post a sample pf your data?