Using Filter for Criteria in Multiple Columns and a Specific Row Range?

[Guybrush Threepwood]

Hi all.
Here's a head-scratcher for you all...
I have linked to an example workbook in Google Sheets below (unfortunately I don't have Excel on my home PC).

Basically I have one worksheet - "Sheet 2" - with a bunch of data.
I have another worksheet in the same workbook -"Sheet 1" - that I need to reference some of the data in Sheet 2.
I have two tables in Sheet 1. Each table in Sheet 1 needs to show values based on data in column A ("Company"), Column B ("Activity"), and Column C ("Person"), as well as a row range ("date") in sheet 2. The row range "date" needs to be specific for each financial year with a drop down in Sheet 1.
The data in Sheet 2 can also change in terms of the amount being pasted in - eg, some data sets pasted in my have more columns (greater date range) or more rows.

In my actual workbook there would be a heap of tables and rows in each table, so I'm trying to use the FILTER function, as I believe this would be less resource intensive compared to INDEX+MATCH.

So far I can figure out how to use FILTER and OFFSET+COUNT to reference multiple columns and a constant date range (using set cell references for the row range) that dynamically changes based on different data sets being pasted into Sheet 2, however whenever I try to combine column references with a row range (eg, D3:O3) that references two dates specific in Sheet 1 it always comes back with a "Value#" error.

Is there a formula that will give me what I want using the Filter function, or will I need to give-in and just use INDEX+MATCH?

Does anyone know if what I'm trying to do is possible?

Google Sheets Example

Many thanks to anyone that can help.