I need my footer to print with 7 different names.

[nay]

I am trying to print n copies of the same worksheet but with different footer
names. For example, 1st copy with footer name "Judge", 2nd copy with footer
name "Timer" and so forth until I have all n names used up.

Any help will definitely be appreciated.