I would copy the file with the data into your updated workbook with the
lastest version of the forms and macros.  First delete all sheets in your
updated workbook and then copy the sheets with data into the file.  Make
copies of both workbooks incase problems occur.

One worksheet will remain in your updated workbook because all sheets cannot
be revoed from a workbook.  When you copy in the new worksheet there may be a
sheet that is the same name as the one that remained in your updated
workbook.  this will have a (2) in the sheet name that needs to be changed.

Sub addworkbook()

'open old old workbook
oldwbkname = "c:\temp\book1.xls"

'delete all sheets in this workbook
'one sheet will remain
With ThisWorkbook
  For Each ws In .Worksheets
     If .Worksheets.Count > 1 Then
        ws.Delete
     End If
  Next ws
End With

'open old old workbook
Workbooks.Open Filename:=oldwbkname
oldbookname = ActiveWorkbook.Name
With Workbooks(oldbookname)
  For Each ws In .Worksheets
     With ThisWorkbook
        lastsheet = .Worksheets.Count
        ws.Copy after:=.Worksheets(lastsheet)
     End With
  Next ws
End With
End Sub