Due to our product differing so greatly with each enquiry/order we have
developed a workbook which creates a new sheet with each enquiry(approx 200
per month) Each sheet reads the customer data base info(another spreadsheet)
and holds the quote, jobsheet and d/note info which operate off macro's(I am
self taught so be gentle). We have recently included a data sheet at the end
of the workbook which stores the info from each sheet in table form. How can
I get the info from a previously created sheet to uopdate info, relating to
that sheet, if it changes bearing in mind that each time a new sheet is
created in inserts a line in the data sheet so the data is always moving?