easier way to copy?

[JOEE1979]

Is there a faster way of Adding columns to my table?
Row 2 are the names of the "Worksheets"
Rows 4,6 & 7 are formulas that stay the same (they calculate the numbers in the respective column)
Row 5 gets extracted for the worksheet page
Rows 8-310 copy cells from their respective worksheets

I have so many worksheets to make
I was wondering if there is a way to do this easier,
maybe once I open a new worksheet and give it a name, it will automatically make a new column.
I would be way faster and less repetitive if its possible.

Thank you

Weekday Bus Cycling - Copy.xlsm
	B	C	D	E	F	G	H
2	Garage	Aberfoyle	Brampton	EG1	EG2	Hamilton1	Hamilton2
3	Days	MTWTF	MTWTF	MTW	ThF	Mtu	WTF
4	Next Run	Tomorrow	Tomorrow	Tomorrow	Tomorrow	Tomorrow	Tomorrow
5	Units Ready	1	10	10	10
6	Remainder	0	0	0	0	0	0
7	Good Until	Tomorrow	Tomorrow	Tomorrow	Tomorrow	0:00	0:00
8	1	0:00	0:00	0:00	0:00	0:00	0:00
9	2	0:00
10	3	0:00
11	4	0:00
12	5	0:00
13	6	0:00
14	7	0:00
15	8	0:00
16	9	0:00
17	10	0:00
18	11	0:00
19	12	0:00
Planner

Cell Formulas
Range	Formula
C4:H4	D4	=IFERROR(SMALL(D8:D1048576,COUNTIF(D8:D1048576,"<"&$C$1)+1),"Tomorrow")
D5	D5	=Brampton!K1
E5	E5	='EG1'!K1
F5	F5	='EG2'!K1
C6:H6	D6	=COUNTIF(D8:D1048576,">="&$C$1)
C7:H7	D7	=IFERROR(SMALL(D8:D1048576,COUNTIF(D8:D1048576,"<"&$C$1)+D5),"Tomorrow")
D8	D8	=Brampton!D5
E8	E8	='EG1'!D5
F8	F8	='EG2'!D5
G8	G8	=Hamilton1!D5
H8	H8	=Hamilton2!D5
C5	C5	=Aberfoyle!$K$1
C8:C19	C8	=Aberfoyle!D5

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
R8:AA60,D15:P60,D61:AA108,C15:C108,C109:AA1048576,C8:P14	Cell Value	>$C$1	text	NO

 

[Skyybot]

I've read this multiple times and I think that I understand what you are trying to accomplish. Each Bus Line has it's own sheet? And this is the master sheet that shows specific information from the Bus Line sheets? And you have a growing fleet, or this spreadsheet hasn't been used in a while?

 

[Skyybot]

I've read this multiple times and I think that I understand what you are trying to accomplish. Each Bus Line has it's own sheet? And this is the master sheet that shows specific information from the Bus Line sheets? And you have a growing fleet, or this spreadsheet hasn't been used in a while?

And you need to add columns for new Bus Lines?

 

[JOEE1979]

And you need to add columns for new Bus Lines?

Each sheet is a different garage, where we park buses.
everynow and then we change the schedule, or we add/remaove garages depending on the season and requirements.
So I dont want to keep chnaging the main sheet, I just want to add a new column, and it will hopefuly do the rest

 

[Skyybot]

Each sheet is a different garage, where we park buses.
everynow and then we change the schedule, or we add/remaove garages depending on the season and requirements.
So I dont want to keep chnaging the main sheet, I just want to add a new column, and it will hopefuly do the rest

Are all of these sheets in the same workbook?

 

[JOEE1979]

Are all of these sheets in the same workbook?

yes

 

[Skyybot]

I don't think that it can be done in it's current setup since there are so many specific references. At least not easily.

 

[JOEE1979]

ok thanks

 

[JOEE1979]

ok thanks

In cell("C2"), it shows "Aberfoyle"
In cell("C8"), it shows "=Aberfoyle!D5"

is there a way to make a shortcut there, for example cell("c8") would be "=C2!D5" (maybe something like that)

 

[Peter_SSs]

I have so many worksheets to make

Are you basically making them all at once or do you mean that you might make 2 today and 4 next week and 3 a month later etc?

Do you ever re-name worksheets after giving them their initial name?