Updated filtered data on next sheet
 

My workbook has a portfolio of around 5000 entries regarding clients who have
been availing facilities like House Loans, Lease Finance and Business Loans
(Book 1)

Nature of such loans is classified in clomun Q

I want the Book 2 to be reflecting the records with respect to "Housing
Finance" entered in Book 1, being automatically updated with each new entry,
and similarly withBook 3 & Book 4 showing the other 2 classes of loans.