Howdy! I feel like this has a super simple solution that I can't figure out.
Sub PrintAll_IDs()
    For Each myCell In Worksheets(1).Range("B1:B16")
        Worksheets(2).Range("D5") = myCell.Value
        Worksheets(2).PrintOut
    Next myCell
End Sub
This code works great to print out a range of names using a static template. My only issue is that I have to manually update the range currently, meaning if there are 16 names, I currently have to specify .Range("B1:B16"). I know there's a way to streamline this so that it automatically knows to end when it finds the first blank in the series, but I'm not sure how to write that out? Any help would be appreciated! Worst case I'll just update it manually