I figured it out! I was pasting the data from an advanced filter into
the "County Records" sheet after I put the name of the source sheet in
S4. Even though the data was not going into the cell, it was erasing
the entire sheet before the data was pasted, and eraxing the sheet name
in S4 with it. I saved the original sheet name as a variable, then
pasted it into S4 after the clearing and pasting was done.
Thanks for the help!