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

 

[JOEE1979]

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?

I add and take away sheets as needed

 

[Skyybot]

=Aberfoyle!D5 references the cell on the sheet Aberfoyle cell D5

 

[Peter_SSs]

nd take away sheets as needed

When a sheet is taken away, should its column be deleted from the Planner sheet.

I also added an extra question to my last post - you answered too quickly.

 

[JOEE1979]

When a sheet is taken away, should its column be deleted from the Planner sheet.

I also added an extra question to my last post - you answered too quickly.

yes to both questions

 

[Peter_SSs]

yes to both questions

Thanks. I did have something in mind but ..
- renaming worksheets at a later time would cause that idea to fail, and
- on further consideration I think my idea wasn't going to work anyway.

I'll think on it some more, but at the moment I am not very hopeful.

 

[JOEE1979]

Thanks. I did have something in mind but ..
- renaming worksheets at a later time would cause that idea to fail, and
- on further consideration I think my idea wasn't going to work anyway.

I'll think on it some more, but at the moment I am not very hope

Iwas hoping if there is a way I can make it follow a pattern to atleast make it easier, an I can delete the columns that I no longer need manually