Thanks to everyone who responded with some great ideas. Another user
verified that when using the Copy function of Advanced Filter, when it
copies and theres already data in cells anywhere below the targeted area, it
wipes them clean.

What I ended up doing was Advanced Filter / Copy to another location on the
same sheet out of the view area...then referenced those cells on Sheet 2
instead of doing a copy to Sheet 2. Problem solved.

Now my only issue is when I protect the sheet, and try to run the macro
that runs the Advanced Filter it says it can't run on a protected sheet. Is
there any way around this? I want to protect the sheet because it's
basically a form that end users will use over and over and if data in any of
the formula cells gets changed, it will mess up the rest of application.
Thanks again.