I would like to use excel to organize the data. I have used a file splitting program to get more manageable sizes, and now have 75 .csv files with about 1000000 lines each to contend with. I need to find a particular value and the data contained in the row (the data is dispersed through out the 75 files). All I can come up with is individually opening the 75 .csv files and using the filter to get the lines I need and copying and pasting them into a designated file.

I am new to this much data and don't know any programming. Any suggestions?