Recording a Macro with Filtering and variable cell numbers

I am trying to record a macro that allows me to filter out certain information and copy and paste the information needed into another sheet -- the issue I am having is the cell numbers will vary each time so the macro errors out. Is there a way to move rows to another spreadsheet based on there being information in a certain column.

In my situation I have the following information:

A: Entity
B: Building
C: Unit
D: Resident
E: First Name
F: Last Name
G: CHC
H: CHC Date
I: Last Payment Date
J: Resident Balance
K: Assessment Amount
L: Assessment Frequency

I am wanting cells that contain: AD, DL, DM, FD, LP, PP or RM in column G to be moved to their own tabs.

Please help!

Thank you,

Ashley

Here is an example with both a before and an after. Normally there will be about 600+ accounts but for this purpose I only kept a few. The amount of accounts for each tab will be different everytime the macro is ran so it needs to move it based off of column G "CHC".

Thank you.

There are 7 CHCs under column G

RM has all the RMs
PP has all the PPs
AD has all the ADs
and Pre-Legal and Demand has the following: DL, DM, FD, LP

Thanks!

There are 7 CHCs under column G

RM has all the RMs
PP has all the PPs
AD has all the ADs
and Pre-Legal and Demand has the following: DL, DM, FD, LP

Thanks!

Thank you so much! This is great!