Using multiple columns from different boards but same client notes to generate a summary based on date ranges.

Within Monday I have multiple boards that have data from a consultant working on a client. These come from a weekly report they submit and their daily QuickBooks time entries with notes. I would like to reference multiple columns from different boards, but with the same client (as defined by a shared status/naming convention) and generate text for an email to send to the client on a weekly or monthly basis. Is this possible with Monday functionality? No third party apps.