Printing using data from another worksheet

[Ariana1701]

I would like to print a worksheet changing only one field/cell (B27) with information from another worksheet ranges A1:A100.
If there is no information in cell, would like it to skip.

 

[Ariana1701]

I would like to print a worksheet changing only one field/cell (B27) with information from another worksheet ranges A1:A100.
If there is no information in cell, would like it to skip.

Still waiting for some help with this