Print range based on cell value

[noisyland]

Hi everyone. I require the ability to enter a value into a data entry cell (lets say 100tonne) that will define the set print range of labels within multiple sheets - then magic will happen and they will all print out at once. If I increase the cell value (for example to 165tonne) then the range of printed labels will increase to cover the required unit ranges. Please forgive my lack of correct terminology and I would be incredibly appreciative of any suggestions on how to achieve this task.