Linking Cells/Workbooks

[Pdavdra]

Hi All,

I'm trying to create a summary page that automatically updates with certain values when creating invoices on excel. Is this possible? I want to be able to render different invoices but have a summary sheet which keeps all the data in one. What's the best way to go about this? I want the summary page to link to the certain bits of the invoice. For example the invoice numbers, dates and amounts.

Thanks
Pj