Our consultant was actually the one who originally set it/created them this way so that individual outputs could be generated and sent to specific staff. I'll look at this multi sheet option to see if it might work for some of the other reports we are running.

Thanks
Karin