Excel Sharepoint Help: Conditional Formatting & Data Autofill

[Sunshine8790]

Hello,
I have a spreadsheet on Sharepoint that I'm trying to make work.

The purposes:

1. To allow people from our building can add their name and birthdays.
2. To have conditional formatting that automatically highlights all rows containing dates from the current month.
3. To automatically populate corresponding cells in the month tabs so that you can go to say... March and see a list of everyone's birthday according to dates like a calendar - with dates of the month along the top (so column A is the 1st, B is the 2nd, etc... to the last day of the month). Column A would contain everyone with a birthday of the 1st of that month, etc.

I'm not sure how to get this to work. I'd like the main sheet to always highlight all rows (From B over, not A) for the current month, and always show all those highlighted rows at the top so they're together and not scattered.
And I have no clue how to get the month tabs to automate from the main sheet.

Any help appreciated.

This is the main tab:

Birthday Spreadsheet.xlsx
	A		C	D	E						K			N
1	Today's Date		Name	Birthday	Month
2	8/17/2023		Example A	1/1/1998	1						8
3	This month's birthdays will automatically show highlighted.		Example B	1/1/1998	1						8
4	Feel free to enter your name and birthday.		Example C	12/22/1980	12						8
5			Example D	1/1/1971	1						8
6			Example E	1/1/1996	1						8
7			Example F	1/1/1957	1						8
8			Example G	11/19/1992	11						8
9			Example H	11/26/1993	11						8
10			Example I	4/4/1994	4						8
11			Example J	1/1/1980	1						8
12			Example K	3/23/1993	3						8
13			Example	1/1/1993	1						8
14				1/21/1971	1						8
15				5/30/1984	5						8
16				9/22/1985	9						8
17				6/9/1987	6						8
18				6/11/1998	6						8
19				6/11/1998	6						8
20				1/1/1989	1						8
21				1/1/1971	1						8
22				1/18/1976	1						8
23				9/27/1950	9						8
24				8/29/2002	8						8
Main List

Cell Formulas
Range	Formula
A2	A2	=NOW()
E2:E24	E2	=MONTH(D2)
K2:K24	K2	=MONTH($A$2)

This is the January tab (all the other tabs are the same way as this one for each of the months):

Birthday Spreadsheet.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
1	1/1/2023	1/2/2023	1/3/2023	1/4/2023	1/5/2023	1/6/2023	1/7/2023	1/8/2023	1/9/2023	1/10/2023	1/11/2023	1/12/2023	1/13/2023	1/14/2023	1/15/2023	1/16/2023	1/17/2023	1/18/2023	1/19/2023	1/20/2023	1/21/2023	1/22/2023	1/23/2023	1/24/2023	1/25/2023	1/26/2023	1/27/2023	1/28/2023	1/29/2023	1/30/2023	1/31/2023
2
3
January

Cell Formulas
Range	Formula
B1:AE1	B1	=A1+1

Here is an image of what the spreadsheet looks like: