Hi
I have a template which is used in every worksheet opened, it conttains items #'s and description of each product so for example if i am adding Milk the new sheet with be default sheet the template will contain the data of the milk including item # product name etc...
so problem is now i have so many products i want to make them into one main sheet so it will have to pull only item # from every sheet and every sheet i might add and put them into the main excel page when i press the button load or any other ways