Has anyone ever FTP a file/data directly into an Excel worksheet from a FTP sever?

At present I manually FTP these files when they are created and drop them onto my hard drive then i export it into Excel for processing. This is becoming very time consuming as the number of files are growing in number.

Regards,
TDR