INDEX&MATCH between sheets

Having a little trouble with index&match between two sheets of tables.
As I choose filters in column A 'Üür_kulukohad!' the data should change accordingly on top tables and same with the tables down below.
But I can't get my index&match formulas to work in columns AF to AH.
I should somehow match them with the A column on the same sheet?
Also it should do the same if I change filters in column L.

And I have no idea what's happening in columns AM to AX - why does changing the filters in column A mess up the tables from AM to AX?

Yesterday (or few days ago now already) I was struggling with all the tables. Now I have progressed with the formulas, but some errors still remain, as I mentioned in the first post here.
Can't get the AF, AG and AH columns to act the same way as Z to AE and some strange things happening in AN to AX (like row 19 disappearing, even tho I only filtered out row 18 and 24)