I have a couple of tables in one spreadsheet, each in seperate sheet.
CLIENT (id, name, adress etc.);
TASKS (id, id_client, name, date, etc.);
DOCUMENTS (id, id_client, name, localization etc.);
CLIENT_MEETINGS (id, id_client, id_meetings, name);
MEETINGS (id, name, time, place, person);
etc.

I would like to create a report for a specific client. It'd display choosen client's tasks, tasks, documents, meetings etc. preferably, on one sheet. I was thinking about creating a couple of pivot tables, but then there'd be a seperate client's filter to each. Is there any way, to create one common filter? or maybe, You have some other suggestions?