VBA Schedule Help 2 questions Master Sheet to Sub Sheets

[Dreamer83187]

I need help on coming up with 2 VBA codes for a workbook. This workbook is setup as a working Master Sheet (“Master Staff”) and a lot of sub-worksheets that are setup as another template that is printed day of. There are two problems that I need to get figured out. Problem 1:</SPAN>
Each of the sub sheets were created with specific dates (ie: 04.03,04.05, etc. etc) The master sheet is laid out with Date (E2:GD2), Time (E3:GD3), and Opponent (E4:GD4). See here: </SPAN>
Excel 2010

	D	E	F	G
2	GAME DATE	Sunday, April 03, 2016	Monday, April 04, 2016	Tuesday, April 05, 2016
3	Game Time	1:05	X	7:05
4	Opponent	Cardinals	X	Cardinals

<TBODY>
</TBODY>

MASTER STAFF​

</SPAN>

Right now it is laid out as an entire 6 month calendar with non-game days being noted in the time and opponent categories with an “X”. What I would like to do is filter the days where there is no X into the appropriate sub worksheet template (ie: Game Date on 04.03.16 -</SPAN></SPAN>wksheet 04.03) the information needs to go into the appropriate cell (Date (“Master Staff” E2) à</SPAN></SPAN> “04.03” A2, Time (“Master Staff” E3)à</SPAN></SPAN> “04.03” A3, Opponent (“Master Staff” E4 à</SPAN></SPAN> “04.03” A4). I need this information to weed out the Days that have an “X” in the time and opponent so it does not pull those days to the sub sheets. Here is an example of what the final sub sheet would look like: </SPAN>
Excel 2010

	A	B	C	D	E	F	G	H	I	J	K	L
1	SUITE ASSIGNMENTS
2												<----Date
3												<---Time
4												<---Opponent

<TBODY>
</TBODY>

Game Day​

Second help is to link each of the subsheets to specific days in regards to scheduling. As of right now I have each staff member setup on a specific line and I would like to just input numbers into the “Master Staff” sheet and then update via button on “Master Staff” sheet to a correlating cell on that specific day sheet. See example of “Master Staff” and “04.03”. I need this button to be able to update all sheets when pushed as these schedules will change. The numbers to cells would be as follows: 1-9: A7:A15, 10-18: E7:E15, 19-27: I7:I15</SPAN>

Let me know if this makes sense. Below are cross sections of the sheets:</SPAN>

Master Staff:</SPAN>
Excel 2010

	A	B	C	D	E	F	G
2				GAME DATE	Sunday, April 03, 2016	Monday, April 04, 2016	Tuesday, April 05, 2016
3				Game Time	1:05	X	7:05
4				Opponent	Cardinals	X	Cardinals
5	SUITE ATTENDANTS	SENIORITY DATE	PAY RATE
6	John Doe 1	1/1/2015	$10.00	X	1	X
7	John Doe 2	1/2/2015	$10.00	X	2	X
8	John Doe 3	1/3/2015	$10.00	X	10	X
9	John Doe 4	1/4/2015	$10.00	X	11	X
10	John Doe 5	1/5/2015	$10.00	X	19	X
11	John Doe 6	1/6/2015	$10.00	X	20	X

<TBODY>
</TBODY>

MASTER STAFF​

Excel 2010

	A	B	C	D	E	F	G	H	I	J	K	L
1	SUITE ASSIGNMENTS
2												<----Date
3												<---Time
4												<---Opponent
5	LOW SIDE				HIGH SIDE				WSS
6
7	John Doe 1 (1)		1-4		John Doe 3 (10)		33-36		John Doe 5 (19)		1903
8	John Doe 2 (2)		5-8		John Doe 4 (11)		37-39 D		John Doe 6 (20)		1909
9	3		9-12		12		40-43		21		1925
10	4		13-16		13		Cambria		22		1927
11	5		17-20		14		44-49,51-52		23		1960
12	6		21-24		15		50		24		1971
13	7		25-28		16		53-56		25		1979
14	8		29-31		17		57-60		26
15	9		ABC 32		18		61-65		27

<COLGROUP><COL style="BACKGROUND-COLOR: #dae7f5"><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP><THEAD>
</THEAD><TBODY>
</TBODY>

Game Day​

​