Capturing dynamic data

I have an Excel workbook with a summary spreadsheet that reports a daily total. This total changes every day. I would like to capture the daily total in a table on the same worksheet as the summary table, so the historical record is preserved.