I am trying to set up a new purchase ordering system using Excel. I am
trying to set up a macro which will copy the master worksheet and number it
as the next PO is needed. We have a separate workbook for each job and PO's
are listed as XY-001, XY-002 ,...