Search and Delete Across Multiple Sheets According to Values in Sheets

I have roughly 50 sheets open that will contain data for my first sheet, essentially just vlookups across these other sheets. However the problem is the data on these sheets are all different and I want to delete all the rows not containing a certain value in column A of all the sheets, on the first sheet, nothing should be deleted, that sheet is just called Sheet1. Also all the sheets are named differently, not Sheet1, Sheet2 ect..

I need some sort of If statement that says the following for all 50 sheets:

If Column A has ‘Equities’, then delete everything except the line that says 'Taxable Fixed Income'. Some sheets do not have ‘Equities’ though, and for these sheets I need the row labeled ‘Account’.

Is this possible to do across all 50 sheets? The number of sheets will always be changing too..

Or could I do it another way?

A member was nice enough to help me with the below code, I was going to use it after this problem was resolved, but maybe there is an easier way…

Please Login or Register  to view this content.

Column A has the Account names on the template sheet. The following sheets are named the Account names, and the above formula works to return the values in column 3. However there is a bunch of junk in the Account sheets that initially I was thinking about just deleting with the above post.

However, could I get a fancy formula to look at the Account Name, then find the corresponding sheet, then have somesort of statement that says, if this sheet has ‘EQUITIES’, then use the data in the row that says ‘Taxable Fixed Income’. If the account does not have ‘EQUITIES’, then use the row ‘ACCOUNT’.

For the attached example spreadsheet, you can see more clearly what the desired result would be.. Thanks everyone for all your help!