The difficult I do immediately, the impossible takes a little bit longer.

Queries

Append and/or Update Data to Table created Dynamically...

Function UpdateServiceCalls()
'From http://www.access-diva.com/

Dim strSQL1, strSQL2, strSQL3, strSQL4, strSQL5 As String
Dim YearMinus0, YearMinus1, YearMinus2 YearMinus3, YearMinus4 As Long

YearMinus0 = Year(Date)
YearMinus1 = Year(Date) - 1
YearMinus2 = Year(Date) - 2
YearMinus3 = Year(Date) - 3
YearMinus4 = Year(Date) - 4

strSQL1 = "UPDATE qryServiceCallCount " & _
          "INNER JOIN tblFiveYearsData ON qryServiceCallCount.eAccountNumber= tblFiveYearsData.AccountNumber " & _
          "SET [" & YearMinus0 & "-ServiceCalls" & "] = [qryServiceCallCount]![CountOfscServiceCallID] " & _
          "WHERE (((qryServiceCallCount.yYear)=Year(Date())));"

strSQL2 = "UPDATE qryServiceCallCount " & _
          "INNER JOIN tblFiveYearsData ON qryServiceCallCount.eAccountNumber = tblFiveYearsData.AccountNumber " & _
          "SET [" & YearMinus1 & "-ServiceCalls" & "] = [qryServiceCallCount]![CountOfscServiceCallID] " & _
          "WHERE (((qryServiceCallCount.yYear)=Year(Date())-1));

strSQL3 = "UPDATE qryServiceCallCount " & _
          "INNER JOIN tblFiveYearsData ON qryServiceCallCount.eAccountNumber = tblFiveYearsData.AccountNumber " & _
          "SET [" & YearMinus2 & "-ServiceCalls" & "] = [qryServiceCallCount]![CountOfscServiceCallID] " & _
          "WHERE (((qryServiceCallCount.yYear)=Year(Date())-2));

strSQL4 = "UPDATE qryServiceCallCount " & _
          "INNER JOIN tblFiveYearsData ON qryServiceCallCount.eAccountNumber = tblFiveYearsData.AccountNumber " & _
          "SET [" & YearMinus3 & "-ServiceCalls" & "] = [qryServiceCallCount]![CountOfscServiceCallID] " & _
          "WHERE (((qryServiceCallCount.yYear)=Year(Date())-3));

strSQL5 = "UPDATE qryServiceCallCount " & _
          "INNER JOIN tblFiveYearsData ON qryServiceCallCount.eAccountNumber = tblFiveYearsData.AccountNumber " & _
          "SET [" & YearMinus4 & "-ServiceCalls" & "] = [qryServiceCallCount]![CountOfscServiceCallID] " & _
          "WHERE (((qryServiceCallCount.yYear)=Year(Date())-4));

CurrentDb.Execute strSQL1, dbFailOnError
CurrentDb.Execute strSQL2, dbFailOnError
CurrentDb.Execute strSQL3, dbFailOnError
CurrentDb.Execute strSQL4, dbFailOnError
CurrentDb.Execute strSQL5, dbFailOnError

End FunctionSet tdf = Nothing
Set db = Nothing

End Function

1.  Write your APPEND query to add data to all fields that were not dynamically created, such as... Account Number, Primary Name, DBA, etc...  Let's call this one *qappFiveYearsData*.
2.  Then write the code for UPDATING the dynamically created fields.  Note, the qryServiceCallCount was needed to get total count of Service Calls for every year for each Account (Client)...

3.  Create a Button and in the On_Click event place...

        DoCmdSetWarnings False
        DoCmd.OpenQuery "qappFiveYearsData"
        Call UpdateServiceCalls
        DoCmd.SetWarnings True

You need to add your own Error Handling code!
aaaaaaaaaaaaiii