VBA to fetch data from other sheet and print until last row.

want to automate label creation fetch data from sheet 1 and print label from sheet 2 until reach last row. for reference i am attaching sample data.