Excel Macro to copy text and append

Hello,

I recorded a macro in Excel where I copied the text from one cell and appended that text to the values in several other cells. The problem however is that Excel is not copying that data in new worksheets. It is just taking the value from the first worksheet and pasting that in all subsequent worksheets.

For example:

32-0151-8715
8716
8717
8720
8719

I want to take the first part (32-0151-) and append it to the front of all the cells below. The values will be different (but in the same format) for each worsheet, however Excel is just copying the values from the sheet where I recorded the macro, instead of copying and appending the new data each time.

Another example of data I am trying to copy/paste:

0025901E83B0
0025901E8514
0025901E851C
0025901E83D4
0025901E8604

Trying to copy the first 10 digits above and append to the front of these rows:

B1
15
1D
D5
05


Is there any way to do this?

Thanks!