SFTP latest file from Windows server to Unix host

Hi All,

I am SFTP ing file from Windows server (Sydney) to Unix host in London (both servers are on different timezones). It appears the upstream (Windows server team) does not do a file housekeeping activity and henceforth there are multiple files i.e. each week the script is scheduled to run and is required to sftp the latest file.

Kindly clarify on the below:
i) How can I SFTP just the latest file?
ii) In another script , I used if [ -f filename* ] option which fails since there are multiple files in the directory. Please let me know how can we look for the latest file in directory.

This would be a Windows scripting question, not a UNIX one.