I have a Excel workbook set up with a report that I run
for many clients. Their records are individually defined
and their names listed in a combo box. As such, when I
select their name from the scroll bar, the report updates
with their info.

I know very little about macros but know there must be a
way to select each name from the scroll bar and then copy
the hardcoded data onto seperate worksheets from Client A
to Z. Currently doing manually. Thanks.