Hi all-
didn't know exactly what to call this, so my apologies if this has been
covered before.

Here's what I want to do:

1) my company has Excel Sales Orders with many different fields --
dates, dollars, contacts, etc.

2) at the end of the week certain information form the Sales Orders
needs to be transferred to an Excel Summary Sheet -- rows and columns
set up. This is currently a cut and paste operation.

My question is: can I reformat our existing Sales Orders (and Summary
Sheet I imagine) so that once the required information is entered into
the Sales Orders and then the Summary Sheet is opened, the Summary
Sheet will update and populate automatically with the information from
the Sales Order?

Thanks in advance for any help/advice!