Macro or VBA Help needed for Advanced Filter and auto update destination workbooks

Hi Folks,

I think this is an extremely tough one, not even sure this is possible!

I need a Macro or VBA to do an advanced filter based on multiple criteria (Filter Criteria = Cell values of "T2 to xldown), then copy advanced filtered data and paste it into new sheets individually (e.g. Add sheets for "SDG", "OPD", OTD" etc.). Please note that the criteria may vary.
Also I have some other workbooks which are I already saved in a share drive ("D:\Public\users\") the workbooks names are same as Filter Criteria (e.g. "SDG.xlsx", "OPD.xlsx", "OTD.xlsx"). After run the advanced filter Macro or VBA then I want to update all these workbooks with advanced filtered data. Is this possible by using a Macro or VBA?.

I have attached a excel file of what I'm trying to accomplish. Thanks in advance for your expertise!

Joshi