Using Array(s) to filter 13k+rows with 600+ keywords

this has been one frustrating day, that's for sure. :-/

here are the questions that i actually have.
is there a more efficient way to do this? Or even an easier user interface. I mean, i put it together, so i know how to work it. But, when i pass it on for someone else to use, that's another story.

I work 10K+ rows. Usually around 60-70k. i have 600+ key words that i am using to filter out the data with. with all of the sorting that i have to do, one filter is still way to much data to sort through all at once. So, i broke it up into 15 different filters.

I have around 600 keywords I am filtering for right now.(and it will continue to grow). The number of rows typically exceed 10k. When I apply the filter, it doesn't catch everything. Maybe 60-65%. And i have to go and eyeball the rest that need to be removed. So, i broke up the arrays into smaller chunks to make it easier on the eyes. While sifting through what the filters don't catch, i'm deleting the ones i don't need and moving the ones that i want to keep to a different sheet, just so i can keep myself from going over the same ol' data over and over again, just because one filter doesn't catch it.

Is there a more efficient way to get the same results?

I download a list of data then export to excel. When I copy and paste the data to this sheet, it messes the Array's all up and I have to go back and correct every cell because it gives me a reference error showing that file path back to where it was saved previously. Is there a way around this? Maybe a Macro or something?

(i just thought of this, but would protecting sheet, workbook or Mark as Final, solve that problem?)

I really appreciate the help i have received from all of you folks in the forum. I hope that i will be able to pay it forward one day.