Learn how to select sheets with the Excel VBA Select method: by name or index, multiple sheets at once, and adding sheet
Learn three methods to zero-pad numbers in VBA: Format function, Right with String function, and Application.WorksheetFu