Hi,

Could someone please advise how can I achieve following task:

We have few guys in office who use excel worksheet to generate invoice for
our clients. The format of worksheet is standard for all users but I like to
generate the summary of all invoices they make.

In other words, as soon as they generate a new invoice it should be added to
the master file. I need only few cells to be copied to master file like
invoice No, amount, due date etc.

Let me simplify further: How can I copy Cell "A1" & "B5" values to a
independent master file. Every time when new values are added to these cells
it should automatically added to the database.

Any help or advise would be highly appreciable.

Thanks
Kevin