Macro to open and search files

[Russyboy]

Hi, I'm trying to create a macro that will search various files for a reference number and once found to highlight/copy and paste it somewhere else.
I know how to get one file open searched and closed but not sure how to write a macro that will then more onto subsequent file. All files are in the same location.

Any help is very much appreciated.

thanks for your time