I have a worksheet where new data sets for individual customers are created from the Master Sheet.
When a new customer comes in, we make Copy Of [Master Sheet] → Sheet 1, Sheet 2, Sheet 3.
So the sheets for the customers do not exist at the start of the day.
The number of sheets that exist by the end of the day are undefined but always under 50. So this is not an infinite data series.
Our customers all have a fixed customer identification, eg A1234567.
We do not know what the sheets will be called at the start of the day, but the sheets will always be named after the customers, so they will only have 8 alphanumerics and nothing else. A1278952, Q7282956, H3344556.
The Master Sheet is called the Template. There is also a Data Sheet. We do not want to draw data from them. So I also need to code for drawing data from sheets only with 8 alphanumerics, but not sheets called Template or Data Sheet.
The range of products and data entered is always from a fixed range.
So Sheet 1 (or Sheet 50) 's data can be limited to the data found in specific cells. I do need to code for drawing numeric or text data, because some of the data needs to be copied from drop down boxes/ cells with formula in them.
I’m trying to create a summary sheet for the end of the day.
So this sheet will need to show all the customers (sheets created).
It will need to draw data from the individual customer data sheets created during the day.
My spreadsheet skills are quite low (hence my nickname). How can I do this?