I wish to know how automatically input data into a table - from a table at the end of every calendar month.

So I want only one cell of data in table one which already has dynamic data to be transferred to table 2 which is currently empty. So at the end of each moth the dynamic data in one will be stored in table 2 to keep record of the monthy changes throughout the year.

Currently we are only using table one. We need table 2 to create graphs of data which record the monthly figures.

So I would like to know of a formula which would input data from a given cell on a given date (end of the month)

Thanks