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