Finding Values Contained in an Array in a Sheet

Is this even possible? I have a user enter whatever they want to find in Column A of a random worksheet they are working in. I have written code to store this as an array

Dim ElmArr() as String

Set ElmArr() = Range("A1" & Selection.End(xlDown))

The add-in opens the file(s) that the user wants to pull data from. The ElmArr is what the code is to search for; once it's found it pull data from the same row but a different column and stores that in another array. How can this be done?