Apologies if this is considered somewhat novice but I need help with an excel Macro as my vba skills arent good. The macro will copy data from a row for x (INPUT) number of times ,allocate a sequential reference number to it, and then transfer this to a new sheet, every time the process is repeated the copied data should be pasted after the last row in the new sheet and use the last sequential number generated.

How It Would Work