Copy cell from a column into multiple worksheets

Closed
Report
Posts
4
Registration date
Tuesday December 27, 2016
Status
Member
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.