Formatting and moving data to another sheet via Vlookup? or VBA ? or Something Else

[Andy Donegan]

Hi I am currently trying to produce a spreadsheet for an entry system to sort out swimmers in a gala by events they have entered. Currently I have the main entry sheet which I receive back from each swimming club, with the details entered, Columns F to J are y / n answer if Y is selected the relevant matching box in K to O highlights from solid black to green for a time to be entered.
What I a hoping to achieve is once I have received all entrys from every club, to copy the info from the main entrys page below on to each specific event TAB, I will create 25 TABS for all the events.
I have created the output that I am hoping to get and pasted that in below as Event1.

Event 1 Tab Below shows the data I would like to pull through from the main sheet above. The top box is my criteria, so I want all males aged 9 entered for the backstroke. It does not need to filter on 50m, that is just there for the event description.
The box below is still event 1 but for a different age group, males, aged 10 backstroke.
I have searched and read a lot but found many different ways, but I think that with my limited knowledge I am struggling. I was hoping to produce this with a vlookup and if statement, but then I receive lots of blanks.
My main hope is if each event page has the top box with Sex, Age and stroke filter, I can run an if statement or the like to go to Entry Form and list all swimmers who picked yes for that event, and pull through the details.

I have played all last night and this morning and can not get anything near to what I am looking for, if somebody has the patience or time to read my request and point me in the correct direction it would be greatly appreciated.
Please note I have used VBA once now thanks to this forum when a problem was solved by somebody, but I am a novice to the technical stuff, I learn quick and will try solutions.
I also tried advanced filter, but it became messy, I just could not achieve the output I require to help us make the gala planning easier.

Also we do have gala planning software, our problem is that it is so complicated nobody can use it with out the aid of one person, a spreadsheet will make so much easier.

Thank you very much in advance.


Excel 2010

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
4	Swimmer Name	Date of Birth	Male or Female	Name of Club	Age On Day	Backstroke	Breaststroke	Freestyle	Butterfly	IM	Backstroke	Breaststroke	Freestyle	Butterfly	IM
5	name 1	25/05/2002	M	Bradford SC	11	y	y	y	y	y	00:00.0	00:00.0	00:00.0	00:00.0	00:00.0
6	name 2	13/03/1999	M	Bradford SC	14	Y	Y		Y		00:00.0	00:00.0	00:00.0	00:00.0	00:00.0
7	name 3	21/01/2005	M	Bradford SC	8	Y		Y			00:00.0	00:00.0	00:00.0	00:00.0	00:00.0
8	name 4	18/02/2004	M	Ilkley SC	9	y	y	y	y	y	00:00.0	00:00.0	00:00.0	00:00.0	00:00.0
9	name 5	11/03/2005	M	Ilkley SC	8		Y		Y		00:00.0	00:00.0	00:00.0	00:00.0	00:00.0
10	name 6	16/05/1999	F	Bingley SC	14	Y		Y		Y	00:00.0	00:00.0	00:00.0	00:00.0	00:00.0
11	name 7	26/11/1999	F	Bingley SC	14		Y	Y	Y	Y	00:00.0	00:00.0	00:00.0	00:00.0	00:00.0
12	name 8	11/06/2001	F	Bradford Dolphins SC	12	Y	Y		Y	Y	00:00.0	00:00.0	00:00.0	00:00.0	00:00.0

<tbody>
</tbody>

Entry Form​

Excel 2010

	A	B	C	D	E	F
1		Sex	Age	Distance	Stroke
2	EVENT 1	M	9	50m	Backstroke
3
4		Swimmer Name	DOB	Club	Entry Time	Time Swam
5		name 4	18/02/2004	Bradford SC	00:00.00
6		name 24	05/03/2004	Bradford SC	00:00.00
7		name 25	10/05/2004	Bradford SC	00:00.00
8		name 26	04/02/2004	Bradford SC	00:00.00
9		name 27	05/03/2004	Bradford SC	00:00.00
10
11
12
13		Sex	Age	Distance	Stroke
14	EVENT 2	M	10	50m	Backstroke
15
16		Swimmer Name	Age	Club	Entry Time	Time Swam
17		name 13	23/03/2003	Bradford SC	00:00.00
18		name 29	04/05/2003	Bradford SC	00:00.00
19		name 40	05/12/2003	Ilkley SC	00:00.00
20		name 48	07/08/2003	Keighley SC	00:00.00
21
22
23

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Event1​