Copy cell from a column into multiple worksheets [Closed]

Registration date
Tuesday December 27, 2016
Last seen
December 28, 2016
Good Afternoon!

I've got a column of data (Months) that I need to insert into a cell in multiple worksheets.
I know if it was within one worksheet I'd just drag the formula down to get it to change. Is there a way to do that in a range of tabs? It needs to be done way to many times and I'd rather not manually enter it.

Ex: ='Adjusted Unit Lifespan'!D12 then ='Adjusted Unit Lifespan'!D13, ='Adjusted Unit Lifespan'!D14 all into cell N2.

I've actually got a couple of these I need to do but I figure if I can get some direction on one I can use the same method for the other spots.

Thank you so much for your help! :)

Just in case this is needed, the worksheet names have either "Cedar Park" "Cedar River" or "Golden Pines" as part of the worksheet name.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!