Waqkas,
Another great question.
Take a look at the starter script below:
$targetdirectory = "<whatever the location path is>"
$sourcedirectory = "\ghy-kih\Test\noname.xlsx"
if (!(Test-Path -path $targetdirectory)) {New-Item $targetdirectory -Type Directory}
Copy-Item -Path $sourcedirectory\file.xslx -Destination $targetdirectory
This will get you started in the right direction. The only thing missing is the addition of the timestamp to the filename. For that you will need to use the following:
(Get-Date -Format "yyyy-MM-dd")
Take a look here to get a sense of how to put it all together:
https://stackoverflow.com/questions/1954203/timestamp-on-file-name-using-powershell
Good luck !!
Cheers,
Adam