Sorry for the confusing question but it's hard to explain......

I have a very large excel worksheet that I need to print the individual rows on a seperate sheet as it's own page. It looks like a word document when printed individually.

Someone has set one up already but if I add columns it changes the individual page and the only way to fix it is to relink each and every row (there are hundreds).

Any ideas of an easier way to do this?