Is there a way to take the date entered by the user in cell C6 and write code
to:

1) go find the file name that contains that date
2) open that file
3) copy it to a new worksheet in the original workbook

Thanks all for any suggestions.