Copy Certain cells to different worksheet depending on what cell in row is populated

[bnav2118]

Hello- Very new to VBA here and very stuck! Any help will be greatly appreciated.
I have a workbook with several different sheets (individual coverage) and one Master of all sheets combined. On the master I have Columns with Name, employee ID and 8 different coverages. Each sheet is for each individual coverage the employee is signed up for. I am trying to find a way that each time an employee is signed up for and added to the Master sheet, each coverage option amount they enroll for along with their name and employee ID is copied over to the appropriate sheet.

OCSB Billing Remit to Payroll_Working_F.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Name	EE ID	AD&D	Cr Ill Ins	Dental	D C Sp Acct	H C Sp Acct	L T D	S T D	AD&D	VISION	Vol Acc	FlCred	Total EE Cost
2	John	123456	$ 5.00		$ 5.00								$ 6.05	$ 16.05
3	Jane	458972		$ 1.00			$ 500.00							$ 501.00
4	Bob	8587452				$ 5.00		$ 7.00	$ 8.00					$ 20.00
5	Austin	894646123	$ 5.00											$ 5.00
6	Ruben	5465612984	$ 7.00			$ 8.00								$ 15.00
7	James	45813464		$ 7.00		$ 5.00								$ 12.00
8	Lisa	48648		$ 9.00			$ 6.00							$ 15.00
9	Ashley	4874816				$ 8.00								$ 8.00
10	Laura	5897897461				8								$ 8.00
11														$ -
12														$ -
MASTER

Cell Formulas
Range	Formula
N2:N12	N2	=SUM(C2:M2)

 

[bnav2118]

This would be one of the sheets I need data to be moved to.

OCSB Billing Remit to Payroll_Working_F.xlsx
	A	B	C	D
1	Employee Name	EE SS	Deduction Name	Premium Deducted
2
3	John	123456	The Hartford-EO Vol Life & AD&D	$ 5.00
4				#REF!
5				#REF!
6				#REF!
7				#REF!
8				#REF!
9				#REF!
AD&D

Cell Formulas
Range	Formula
C3:C9	C3	=IF(A3<>"","The Hartford-EO Vol Life & AD&D","")
D4:D9	D4	=INDEX(MASTER!#REF!,MATCH('AD&D'!B4,MASTER!B:B,0))