Copy Data from one Worksheet to Another in Excel with condition

[ambz123]

Hi All,

Can i ask how do i copy from one worksheet (master list data) to another worksheet (Recording Form) giving that it only paste in according to the employee name. Because each employee has own tab in the excel recording form file.

This worksheet below is my master list data:

Internal & External Training Summary 2021.xlsm
	B	C	D	E	F	G	H			K
10	Candidate Name	Dept	Title of Course /Seminars	Fees (Before Subsidy)	Fees (After Subsidy)	Date of Course / Seminar	Training Institute			Remark
11	Emp A	Top Management	Build Environment & Property Prospect	$300.00	-	18 & 19 Jan 2021	BCA Academy
12	Emp A	Top Management	Engineering Resilience for Post COVID-19	Free	-	19/01/2021	SCAL Academy
13	Emp B	Top Management	Engineering Resilience for Post COVID-19	Free	-	19/01/2021	SCAL Academy
14	Emp C	Accounts	Engineering Resilience for Post COVID-19	Free	-	19/01/2021	SCAL Academy
15	Emp C	IT	Responding to a Cybersecurity incident in the new reality	Free	-	1/20/2021	bbb
16	Emp D	Production	Coretrade Renewal reinforced concrete	$133.75	-	20/01/2021	AAA
2021 Summary (All Dept.)

This worksheet below is my Recording Form:

Employee Training Record - 2021 (Top Management).xls
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
5	Employee Name		:	Emp A				Date Joined	:	6/15/2006
6
7	Department		:	Management				Designation		Chief Executive Officer
8
9
10	S/No.		TRAINING /			DATE /		TRAINER /			Fees	REMARKS
11			COURSE NAME			PERIOD		ORGANISATION				(IF ANY)
12	1		Build Environment & Property Prospect			18 & 19 Jan 2021		BCA Academy			$300.00
13	2		Engineering Resilience for Post COVID-19 Recovery			19/1/2021		SCAL Academy			Free
14	3		Technical Webinar on Emerging Technologies for Construction in Singapore			21/1/2021		SIT			$21.40
15	4		FRP Reinforcement for structual concrete: Design & Application			2/5/2021		IES			$80.00
16	5		Budget 2021 Webinar			2/19/2021		SCCCI			Free
17	6
18	7
EP071-TBT