Unless wanting to do this repeatedly probably no need for VBA. Standard functionality - import a text file and then AutoFilter

Specifically on "Data" ribbon, option is "From Text", point at correct folder, change file type from "text files" to "all files" to see the file, select and import it and then take default wizard settings and click finish.
Use Autofilter to select what you need