Keeping a copied table with updates values

When you copy a table I believe there is an option to keep the data, or not.

I don't believe it updates the current information though. 

What do you mean by updating yh current information. Can you give me an example?

I think what you're looking for is a 'connected table'.  This is a table that you set up to mirror another quickbase table, and to keep the data in the connected table the same as in the source one.  This is the easiest way to accomplish this, albeit there are a few caveats.  For one, the shortest time you can schedule between 'syncs' is one hour, although you can manually sync as often as you want.  There are other ways to do this as well, such as using native webhooks.  There is an example app in the exchange which demonstrates how those are setup.  The benefit is that the second table can be kept up to date with the source table in 'live' time, not on a schedule.  However, there is significantly more setup involved in this method.