Need Access macro to copy data from one table and paste into another.

I am attempting to create a macro in Access to copy values from column "net" in table "LeaseCalculated" to column "user" in table "Lease". I need the values to match the ID code in each table. For example, if ID code 123 in table "LeaseCalculated" has a value in the "net" column of 25, I need ID code 123 in table "lease" to say 25 in the "user" column.

I know this can be done with a query but it needs to be a macro because I have hundreds of databases that I need to be able to apply it on, as well as any new database that I receive (I get them often). Also, the databases are used by another program, which displays information pulled from the "Lease" table and I can sort the information in that program by the columns in that table but the information is stored in the "LeaseCalculated" table, which I cannot sort the displayed information off of.

Thank you for the reply and sorry about the delay. Here is a sample database but I have excluded many of the columns and tables that exist in my real databases, not sure if they make any difference or not. Hopefully the zip attaches correctly. I do appreciate any help.