I have recently built a file containing roughly 100 client contacts - each tab represents a different client with financial data. What I would like to do each month when I update the data is be able to assign a macro so that I can create seperate workbooks, organized by particular clients, and distribute them appropriately. Not only would this be helpful in reducing the overall file size but, more importantly, I can't have multiple people seeing ALL of the information. I am familiar with macros but have never used them - is this feasible to do? If someone can provide me with a starting point I would greatly appreciate it!