I am writing a macro that will copy the worksheet called Bill of Ladings(BOL) and have the new sheet refrence the current sheet(sheet1) and fill all the data for the BOL. Idealy I would like to make multiple sheets one for every row of data in cells A5-A13, but I am struggling because it seems that the creation of a new worksheet stops the 'for' loop in VBA. I have some rough code but its obiously getting me no where. If you even have a better algorithm for my issue, any help would be greatly appreciated.