VBA copy Value matching Cell sheet name and value

[hajiali]

Hello everyone. I need help with the following:

Date of Payment	2/15/2021
Paid To	JOHN	$50.00
Paid To	BILL	$100.00
Paid To	TOM	$29.00
Paid To	SARA	$200.00
Paid To	KIM	$20.00
Paid To
Paid To

each person in column B will have its own sheet. Within each person sheet Range("C14:C373") will have dates

Using the above Table I need a Macro to copy the Paid amount for each individual to its sheet in column F, matching date in Cell (B55) "MM/YYYY" to the date in Range for each person ("C14:C373")

using above example

sheet(JOHN) cell C24 = 2/5/2021
value in F24 = $50.00

sheet(BILL) cell C300 = 2/15/2021
value in F300 = $1000.00

sheet(TOM) cell C14 = 2/1/2021
value in F14 = $29.00

sheet(SARA) cell C240 = 2/5/2021
value in F240 = $200.00

sheet(KIM) cell C204 = 2/28/2021
value in F204 = $20.00

Notice the Day is not important so only match the Date "MM/YYYY" to the "MM/YYYY" to each sheet in Range("C14:C373")
also the date MM/YYYY will not be duplicated.

note: the Name and paid amount could be 1 person to 7 people.

any help is greatly appreciated.

 

[hajiali]

post is also crossed linked HERE