Excel Macro-concatenate sheets of part nos and quanities into a series of new sheets named by the supplier.

This project involves creating 2 macro based on the excell spreadsheet that I will provide. The spreadsheet contains the following worksheets 1- 1 Worksheet called 'Start' with details of what shortcut keys trigger macros 2- 1 Worksheet called 'supplier' with Suppliers Details 3- 1 Worksheet called 'Hardware' with Parts desc and Parts No with quantities required. [a macro already exists that will copy this worksheet so multiples of this sheet will exist under various 'job' names. This collection of 'job' worksheets is the primary source of data that the macro will need. The project involves concatenating the 'job' worksheets into new worksheets based on the supplier Name from the worksheet 'suppliers details'. Then a second macro to send the worksheet to a suppliers email address.