Create a VBA or formula that can summarise all the info from different sheets that does not have the same description cells

[Waffles255]

2021 Bookings Working Papers (11).xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ
1	WILDERNESS FIRST AID LEVEL 1& LEVEL 2 PFG 15C													02 AUGUST - 06 AUGUST 2021
2		LOCAL	0	MAXIMUM PAX	20
3		INTERNATIONAL	20	PROVISIONAL BOOKINGS	20
4				OFFICIAL BOOKINGS	0
5				CONFIRMED BOOKINGS	0
6				AVAILIABLE SPACE	0
7				WAITLISTED	0
8	NO	OUTSTANDING FEES	BOOKING STATUS PROVISIONAL OR CONFIRMED	FULL NAMES AND SURNAME AS PER ID/ PASSPORT DOCUMENTS	AGE	D.O.B.	M/F	COUNTRY	REG.	MED DETAILS	DRIVERS LICENSE	ID / PASSPORT	INDEM.	ARRIVAL	DEPARTURE	DIET	AGENT (IF APPLICABLE)	SPECIAL REQUESTS / OTHER	TOTAL COURSE COST	PAYMENTS RECEIVED	DATE	PAYMENTS RECEIVED	DATE	PAYMENTS RECEIVED	DATE	PAYMENTS RECEIVED	DATE	SA ID NO	PASSPORT NO	STUDENT TELEPHONE NO	CONTACT IN EMERGENCY	EMERGENCY NO	MEDICAL DETAILS	OCCUPATION	POSTAL ADDRESS	EMAIL ADDRESS
9	1	0.00	PROVISIONAL	BLOCK BOOKING PFG 15C NAME TBA 1													PFG		0.00
10	2	0.00	PROVISIONAL	BLOCK BOOKING PFG 15C NAME TBA 2													PFG		0.00
11	3	0.00	PROVISIONAL	BLOCK BOOKING PFG 15C NAME TBA 3													PFG		0.00
12	4	0.00	PROVISIONAL	BLOCK BOOKING PFG 15C NAME TBA 4													PFG		0.00
13	5	0.00	PROVISIONAL	BLOCK BOOKING PFG 15C NAME TBA 5													PFG		0.00
14	6	0.00	PROVISIONAL	BLOCK BOOKING PFG 15C NAME TBA 6													PFG		0.00
15	7	0.00	PROVISIONAL	BLOCK BOOKING PFG 15C NAME TBA 7													PFG		0.00
16	8	0.00	PROVISIONAL	BLOCK BOOKING PFG 15C NAME TBA 8													PFG		0.00
17	9	0.00	PROVISIONAL	BLOCK BOOKING PFG 15C NAME TBA 9													PFG		0.00
18	10	0.00	PROVISIONAL	BLOCK BOOKING PFG 15C NAME TBA 10													PFG		0.00
19	11	0.00	PROVISIONAL	BLOCK BOOKING PFG 15C NAME TBA 11													PFG		0.00
20	12	0.00	PROVISIONAL	BLOCK BOOKING PFG 15C NAME TBA 12													PFG		0.00
21	13	0.00	PROVISIONAL	BLOCK BOOKING PFG 15C NAME TBA 13													PFG		0.00
22	14	0.00	PROVISIONAL	BLOCK BOOKING PFG 15C NAME TBA 14													PFG		0.00
23	15	0.00	PROVISIONAL	BLOCK BOOKING PFG 15C NAME TBA 15													PFG		0.00
24	16	0.00	PROVISIONAL	BLOCK BOOKING PFG 15C NAME TBA 16													PFG		0.00
25	17	0.00	PROVISIONAL	BLOCK BOOKING PFG 15C NAME TBA 17													PFG		0.00
26	18	0.00	PROVISIONAL	BLOCK BOOKING PFG 15C NAME TBA 18													PFG		0.00
27	19	0.00	PROVISIONAL	BLOCK BOOKING PFG 15C NAME TBA 19													PFG		0.00
28	20	0.00	PROVISIONAL	BLOCK BOOKING PFG 15C NAME TBA 20													PFG		0.00
SEL 15C FIRST AID 02 AUG - 06 A

Cell Formulas
Range	Formula
C2	C2	=COUNTIF($H$9:$H$28,"SA")
C3	C3	=SUM(E3+E4+E5-C2)
E3	E3	=COUNTIF($C$9:$C$28,"PROVISIONAL")
E4	E4	=COUNTIF($C$9:$C$28,"OFFICIAL")
E5	E5	=COUNTIF($C$9:$C$28,"CONFIRMED")
E6	E6	=SUM(E2-E3-E4-E5)
E7	E7	=COUNTIF($C$9:$C$28,"WAITLIST")
B9:B28	B9	=SUM(S9-T9-V9-X9-Z9)

Good Day gents i have a tough one here i have a database in excel spanned over 270 sheets that basically has the same structure as above, however some sheets does have more cell descriptions than others so i cant append it, basically i want to create all one sheet that combines all the info on the sheet while also placing the Course name in Cell A1 of every sheet as well as the N1 Date after each booking it returns. to be able to build reports of it. is there a way i can create a formula that looks on each sheet where the cells start on row 8 for each sheet and the booking information is below that. Can i for example lookup all outstanding fees and it will give me every listing in every sheet that has an outstanding fee, while also placing the Course name and date next to it. Our admin person is very resistance to change so i cannot change the way she does it but hoping there is a way to make it work?