Hi There,
I have a print range as follows:

='Master Data Sheet'!$A$12:$B$300,'Master Data Sheet'!$E$12:$I$300,'Master Data Sheet'!$L$12:$P$300,'Master Data Sheet'!$U$12:$U$300
which you can see is four separate ranges. The problem is I need this to be dynamic. I have tried using offset but didn't get anywhere so I must have been doing it wrong. Can anyone please shed some light on this?

Thanks