Concatenate Macro VBA

[rsrasc]

Hi all,



I need help with a macro. In cell A1, I have the following number: 025

I have 15 different SHEETS with different numbers in cell A1.



In cell B10 (in all 15 sheets), I have the following information:

43610 General Advertising-Full Run


In cell A10, I have the following formula:


="NF-"&A$1&"-"&LEFT(B10,5)&"-"&MID(B10,7,45)&"--Budget 2019"


The result in cell A10, is the following:

NF-025-43610- General Advertising-Full Run--Budget 2019

So, the formula is working fine.


My goal is for the macro to be able to run the formula in cell A10 to 15 different sheets without having to do copy and paste.

Hope I can get some help.

Thank you in advance for your assistance and cooperation.

Cheers!