Every 2 weeks I have a Table of about 25 Agents, and the bookings and commissions they generated - My goal is to provide each agent a listing of their bookings/commissions - just allowing them to see their bookings/commissions, and no other Agents... In regard to the reporting, I know I can do a Pivot Table and use the Filter Option to generate 25 or so individual sheets, from there, I have the issue.. any thoughts on how I could send this in some type of protected mode to each Agent, or any automated way to generate the 25 or so sheets... Again, my goal is to provide the Agents detail just to them. Please advise. Thanks,

Monte