Excel Macro programming

Need an excel macro that will scan through a single worksheet of invoice references i.e. customer, invoice total, description, extras, that can be in fixed positions for referencing. New Calculate button will scan master sheet and produce a new worksheet for each invoice reference. We need to have one worksheet for each invoice - about 80 in total. Also need an amend function where the macro would do a scan for changes in the master sheet and amend any invoice sheets where the master has changed without creating a new sheet. So 2 buttons: Calculate and Amend. The created sheets need to look like an invoice so a border plus table and a few fields for company information, proforma will be provided. Needs to work on Excel 2007 and 2010 but could upgrade to 2010 if needed. Happy to answer any questions.