How to pull in data from multiple boards based on people and statuses

I am looking for advice about how to achieve the following. I have 2 boards that track work done for clients using the time tracker. One is just using the time tracker, and one uses a formula to add 2 time tracked columns together to get a total number. I basically want to take that information from both boards, and send it to a third board. However, I want to be able to only send the information based on a client name (which is a text column and also a status column) and potentially a person column as well. I do not want to pull in each pulse, just the total time that was spent on that client. Throughout the month, the time also changes so it would need to be updated on the third board as well. Anyone have any ideas on how to do this?