Pulling data from a charging file!

I am relatively unexperienced with programming and I am having trouble with a few things here.
I would like to be able to copy a single row of data from a huge sheet containing about 7000 rows on a daily basis. This would be a non issue except that it is not in the same row from day to day. It may be in row 1624 today and 1620 tomorrow basically. In the second column is a unique ID number that says constant though. I need a macro that can find this number and copy the entire row of data to another sheet.

The second issue I am having is that this data is from a .csv file that is posted on the next business day. The name of this file changes day to day because the name of the file is the date it was from.

If anyone can answer one or the other that would be great! I have been searching the forum for a week and have not found anything close enough for me to work with.

Thank you very much for your help and time!!!