Add/Updated One Worksheet from another - Macro/VBA ?

Need some help thinking this one through. What I would like to do is
copy a daily worksheet to a Weekly worksheet that will be an
accumliation of the daily worksheets.

The trick here is the daily information mostly text data often times
includes not new data but just updated data that would need to be
updated on the weekly spreadsheet.

Sometimes the data is in fact new and will need to also be added to
the weekly worksheet..

Looking for help in how best to do this with Macro..Dont think
consolidation works as not adding up data but rather adding new rows
and updating information

thanks for your thoughts

I'm not exactly sure of what you are looking for. However I have some tips that may help.

In a database(excel or other), there should be ways to ensure integrity of the data. If you are copying and modifying records, be very careful about duplicate records and duplicate efforts. If these are two workbooks that have the same record and both are being modified, then which record is correct or more updated??

If you have a workbook that reports(copies records to) to another workbook, you should setup some rules to follow to ensure good management of the data. I would either delete the original record after it was copied or lock it so it cannot be modified again.

You might want to consider using a SHARED workbook for this work.