I have 10 excel files. Each file has detailed sales information for one year. To search those files currently I have to open each annual file and search that year separately. Is there a way to open all the files simultaneously and search them as one big file?

If I have to combine all the separate files into one file to do this, how would I go about making one big searchable file out of 10 small ones?