Macro to copy data between files based on date

[tjsisley]

Hey all,

I have a requirement to create a macro that copies data from one file to a second file based on a date. I have a vision of the end user enters the relevant date in a pop up box and then the macro runs and saves the destination file with the new data. The destination file is in a shared location that all team members have access too.

The source file's are named, "FTA Report" & the data in YYYY-MM-DD, this format is always consistent, the file can have up to 4 sheets, however if that sheet is blank for a specific day then there will be no sheet for that day.
The destination file is also housed in the same area as the shared drive.

Below is the format for each cell - Column A is the date that defines which data is copied over

A	B	C	D	E	F	G	H	I	J	K	L
date	int	int	int	string	string	int	string	datetime	datetime	string	string

thanks for any help guys!