Need to generate a random serial number that automatically populates the transmittal sheet

I am a newbie to excel and require assistance, In the attached, I am looking for a macro to generate random serial numbers in column B. That serial number once populated fully would transpose to the transmittal sheet. I am looking for a button that would save the completed sheet as a PDF document. The user would then save the workbook, close, and use the next row as needed.