Automatically recording content on different sheets into one sheet

Thank you for joining the forum, perhaps any one can assist.

I am looking for a solution, where is able to take certain cell info from the same template (used on different sheets) and record that in a single row on a summary sheet. E.g.

On each sheet, we have a customer name, contract number, quantity ,sales foreign value, sales local value, charge description, charge rate. These sheets are per customer.
1. I would like to create a record sheet and by using VBA macros, record the information off each sheet
2. Each time a new sheet is create the record sheet is automatically updated with the new information
Hope you can assist

Hi

Thanks for the quick response. I can see this working but not understanding. I have included a master template. This will be duplicated and update with figures for each customer. The required fields are those highlighted in yellow.Sumarry Template.xlsm

Ok

Try this solution.

Thanks, will try and let you know. Appreciate the effort.