Using FILTER to copy relevant data from one Excel workbook to another

[Magaletta]

Hi team,

I have attached 2 sample workbooks, in the first, is raw data which will continue to grow (including blank data).
I would like to transfer the row of relevant information to another workbook to report some information.

Can someone please advise how to do this and what formulas to use.

For a reference of the filters I am wishing to use, I have added them as the title of the sheets of workbook 2.

Both workbooks have a few sheets as the real data will be coming from 4 different sheets in 1 work book and then going onto another work book with sheets divided by states.

[Magaletta]

AliGW got any solutions on this one?

[AliGW]

If I haven't responded already, then clearly not.

Administrative Note:

It has been only half an hour since you first posted. Please do not bump threads until 24 hours have passed, and then only once each day. We are all volunteers here who have lives beyond this forum. While you may be awake and working, this is a world wide forum and others may be playing, sleeping or working and not have the time to look into your issues this minute. Patience is important here. If you have an urgent issue, you may wish to look at paying for help in the Commercial Services sub-forum or hiring a professional consultant in your area. Again, please do not bump threads more often than once in every 24 hours: if you get the help you need today, then great, but you really should not count on it. Thanks for your understanding and patience.

[Magaletta]

Thanks Ali,

Sorry for the bump, I will happily wait as i will be going to bed now.

[JeteMc]

Not saying that I can resolve this issue, but perhaps this will help clear things up for someone who can.
In the Excel Help 2 workbook, on the Entity 3 + TAS sheet, do you want only those entries that have both TAS in column C and 3 in column D which would exclude row 8 on sheet 2 of the Excel Help 1 workbook?
I'll also ask if it is really necessary to put the filtered data in a separate workbook as opposed to just other sheets in the Excel Help 1 workbook?