Copy the latest file (only a part of file name and extension is known) from source to destination. (VBScript)

I need to copy a file (latest) that is present in Temp folder to AppData/Roaming folder. But I know that the file name starts with "MSI" and the file extension is ".log" (like MSI*.log where * is a random hexadecimal number). Also, I need to get the path for Temp and AppData/Roaming programmatically. After copying to the destination, I need to rename the file in destination as well as in source. I am very new to VB. How can I do this? Can you please give me some examples?

Thanks in advance.