How to split data to reformat for comparison

I'm trying to validate that everyone has the correct access levels on a system.

The system is called WinSAS
There are 6 databases called Accrual, GroupIns, Industry, Msttrust, Staff, Whsale
Access Type is the actual permissions. All options are listed in the WinSASPerms worksheet.
All Access Types given to a user are the same across all databases given to the user on that 1 line.
Users may have multiple lines to vary the access across the databases.

I'd like to have a report of what we need to do to change the accounts on the SARMS_WinSAS sheet to match the InfraRecords sheet. InfraRecords is the law, this is what people are supposed to have.

Rules:

1. - We cannot modify the InfraRecords sheet as it will be used for everyother application
2. - It is fine to add sheets, add to sheets or reformat sheets as long as InfraRecords is not permanently altered.
3. - Any "Salary" in SARMS_WinSAS sheet that does not match a "Sap Id" in InfraRecords sheet that has an "App Name" of WinSAS should be marked as "Delete"
4. - Any "Sap Id" in InfraRecords sheet that has an "App Name" of WinSAS that is not listed as a "Salary" in SARMS_WinSAS should be marked as "Create"
5. - Each row in SARMS_WinSAS has 3 important columns of "Salary", "Database" and "Group". If these do not match InfraRecord's "Sap ID", "Access Details"(everything is in the 1 cell for Access Details) where "App Name" is "WinSAS" at least once (there can be multiple entries for each person) then we need to mark that as a "Permission to Remove".
6. - All entries in InfraRecords that have WinSAS as the App Name must have each Database and Access Type accounted for in the SARMS_WinSAS sheet. (I think we can use the array from WinSASPerms to look for each one and report on successs or fail) If there is a fail then report should say "Permission to Add"
7. - There may be entries in InfraRecords where the "Profile" in column J is "BA070" which means the Access Details will start with the word "Repview. These lines can be ignored.
8. - Any starting with "Database: SASCheque" can also be ignored.

Perhaps the best way is to extract each permission from InfraRecords and put it into the WinSASinfra sheet in the same format as the SARMS_WinSAS sheet and then a simple comparison can be done. This is why I created the sheet to start with but perhaps you know of a faster method?

Please read and adhere to these simple rules!

1. Use concise, accurate thread titles. Your post title should describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title. The forum is not a design/development agency.

If you are having problems with a particular macro or formula, then post the code and describe the problem with the code: what it does wrong or just doesn't do, etc.