Hi, I have this "huge" excel file now, from where on the summary , i have all the info and by changing one cell (product)(from a drop down list) i get the info for each product. I need now , every month to go to that file, and one by one, change that cell , get the product info and copy each sheet on another file. Could it be possible to have a Macro which do that? Select each product from that cell, and each generated sheet to get copied in a new excell or actually on an existing one? thanks