Copy local sheet to network book

[David Schaleger]

I need VBA to copy a worksheet (pivot table) from a local file "local.xlxs" to a file on the network "remote.xlxs". The caviat is that I want "remote.xlsx" to contain only the most recent version of the pivot table sheet from "local.xlxs".
Manually, I copy the sheet to a new "remote.xlxs" file on my desktop, then copy that file to the network and overwrite the existing "remote.xlxs". I want to automate this daily task.