There are several workbooks, all linked  over an intranet. Different
users enter data from their own area in to their own workbook, which
provides data to other workbooks on the system.

Each week the workbooks are manually backed-up in to an archive
folder and refreshed to allow the entry of new data, but this has had
its problems, due to varying degrees of IT competence resulting in
data loss.

I'd like to create  a routine that would be initiated through the
Click event of a command button, to auto  backup each workbook  and
refresh for new data entry.