Macro Find set criterias to a colomn of number, delete the rows that don't meet criterias

Hello Excel Experts,
I need a macro that will look at column A, number in cell and look for the following criteria:
1 Column A is the identifier #
2 Keep the rows with the highest # for the identifier #. Delete the rows that the number is less
3 keep all the rows that has the word "Tab" (Col E) and Yes (Col I). Delete the rest.

I would appreciate any help on this. I recorded a macro but my file is very large and it took way too long to run. I know there are easier steps to loop the macro and it would go a lot faster. I just can't find exactly what I need.
I have attached a file for an example

Hello Keebellah,
I have the example below the first table. I forgot to mention that on the attachment. Example Table starts at row 5 down to Row 42. The desire results on Table starts at row 47 down to row 66. The highest number to find is in Column C. Column A is just a identifier.

Hello Keebellah,
I should have mention that the step numbers are above the columns in row 2. Plus, I didn't not explain the steps clearly on finding the highest number in column C. I am sorry about that.

Questions 1. Yes, the identifier could have several rows with the highest number
Questions 2 & 3. Yes, the rows will have either Yes, Tab or both and will have the highest number in column c that goes with the identifier col a.

If I could get someone to a least help me do the first part that would be helpful. Have the highest number in Col C for the identifier in column A. Delete the rows that the number is less then the number in col C

YAY!!! This is exactly what I was hoping for, thank you Keebellah!!! I wasn't trying to push for the help, I was thinking I might have been asking for too much. I know the experts, like yourself, are wonderful to offer to help. This site and others that have helped me in the past have been super awesome! I will mark this task solved. I will also add comments to your reputation. Again, thank so much for the help!!!