I am not too sure why the workbook is repeated as another forum user had helped to put the code together.
The date portion is determined by when the report is generated by a 3rd party. The files to be cleansed may be produced weekly/monthly so the date will change accordingly.
I was originally thinking i could create a cell which the user could enter the file name into. For example the user will select one of the four potential file names from a dropdown, enter a date and then i would concatenate the data to arrive at the exact file name in a cell e.g. E27. The vba would then pull the file name based on the contents of said cell. ( i could not find a way to do this after scouring google and other forums).