Invoice data is generated from accounting software and downloaded to Excel
via c:\[workbook name].xls. Urgent invoice data is dealt with immediately
and edited and printed from c:\[workbook name].xls and forwarded to end
users.

However, non-urgent invoice data will be input later by end of the day and
together with the urgent data get downloaded to c:\[workbook name].xls again,
except that the earlier downloaded and edited urgent data will be overridden.
This means that urgent data will need to be edited again together with the
non-urgent data and is a waste of time and effort.

Are we able to do the following?

Create worksheet1 and worksheet2 in workbook.

When urgent data get downloaded, can it be saved in
c:\[workbook].xls\[worksheet1]? Editing can be done in worksheet1 and be
saved.

When urgent data and non-urgent data get downloaded again, can it be saved
in c:\[workbook].xls\[worksheet2] without overriding worksheet1? Urgent data
can be deleted from worksheet2 since it is already saved in worksheet1.
Editing on non-urgent data can be done in worksheet2 and then be saved.

In this way, we do not need to create a new workbook for the urgent data and
we can save same day data in one workbook but under separate worksheets
within the same workbook.

Thanks.