Pulling specific data into another worksheet

[mistyblu3]

Hi everyone!


I know the title is very generic but what I'm trying to do is hard to explain in a short sentence! I'm working with multiple workbooks that I'm trying to combine into one workbook with multiple sheets for 2 reasons: 1-it will eliminate some double entry the client is doing, and 2-I'm trying to get the data streamlined for use in Power BI. Therefore I'm hoping I can find a way to do this, but I'm not sure its possible.


The first sheet (Billing Info) is a list of vendors and their invoice date, amount, project number, etc. The sheets after that are split up by project number (Project 1, Project 2, etc.) and show the PO's that were generated to match the invoices.


What I'd like to do is: anytime something is entered on the Billing Info sheet for Project 1 (or Project 2, etc.), copy data from columns B, C, D, and E (See Billing Info Sheet screenshot below) over to the Project 1 sheet (See Project 1 screenshot below - B into B, C into C, D into D, and E into A). BUT (And this is the tricky part) --- When bringing the data over to Project 1, I'd like to sum the amounts in Billing Info-Column D when the date in Billing Info-Column C (Invoice Date) are the same AND the number in Billing Info-Column A (Site) are the same.


For example:
Billing Info sheet:

Line#	A SITE	B CONTRACTOR	C INVOICE DATE	D AMOUNT	E PROJECT	F PCA	G INVOICE
322	703	Professional Reforestation	09/05/2018	$4,065.38	427405-16	51047	R1840-02
323	680	Professional Reforestation	09/10/2018	$10,279.03	427405-16	51047	R1840-03
324	703	Professional Reforestation	09/10/2018	$6,352.52	427405-16	51047	R1840-03
325	703	Professional Reforestation	09/10/2018	$3,813.38	427405-16	51047	R1840-03
326	703	Professional Reforestation	09/17/2018	$3,022.00	427405-16	51047	R1840-04
327	704	Professional Reforestation	09/17/2018	$18,601.38	427405-16	51047	R1840-04
328	680	Professional Reforestation	09/25/2018	$2,434.00	427405-16	51047	R1840-05
329	703	Professional Reforestation	09/25/2018	-$108.37	427405-16	51047	R1840-05
330	704	Professional Reforestation	09/25/2018	$27,277.51	427405-16	51047	R1840-05
331	676	Western Pacific	01/22/2019	$8,175.50	427405-36	51064	2236
332	676	Western Pacific	01/30/2019	$7,655.00	427405-36	51064	2238
333	676	Western Pacific	02/05/2019	$5,954.50	427405-36	51064	2239
334	676	Professional Reforestation	02/19/2019	$5,627.52	427405-36	51064	R1840-26
335	676	Professional Reforestation	03/06/2019	$3,723.64	427405-36	51064	R180-28
336	676	Professional Reforestation	03/19/2019	$2,524.88	427405-36	51064	R180-29
337	676	Professional Reforestation	03/26/2019	$1,898.58	427405-36	51064	R180-31
338	676	Professional Reforestation	04/01/2019	$1,881.23	427405-36	51064	R180-32
339	676	Professional Reforestation	04/16/2019	$1,860.42	427405-36	51064	R1840-34
340	680	Professional Reforestation	07/02/2018	$25,469.60	427405-46	51064	R1734-33
341	680	Professional Reforestation	07/10/2018	$10,101.38	427405-46	51064	R1734-34
342	680	Western Pacific	07/17/2018	$1,285.00	427405-46	51064	2208
343	681	Professional Reforestation	07/22/2018	$382.50	427405-46	51064	R1734-36

<tbody>
</tbody>

Lines 322-333 would copy over as:
Project 1 sheet:

A PROJECT	B CONTRACTOR	C INVOICE DATE	D INVOICE AMOUNT	E PO DATE	F AFP NBR	G PAYMENT AMOUNT
427405-16	Professional Reforestation	09/05/2018	4065.38
427405-16	Professional Reforestation	09/10/2018	10279.03
427405-16	Professional Reforestation	09/10/2018	10165.9
427405-16	Professional Reforestation	09/17/2018	$3,022.00
427405-16	Professional Reforestation	09/17/2018	$18,601.38
427405-16	Professional Reforestation	09/25/2018	$2,434.00
427405-36	Western Pacific	01/22/2019	$8,175.50
427405-36	Western Pacific	01/30/2019	$7,655.00
427405-36	Western Pacific	02/05/2019	$5,954.50

<tbody>
</tbody>

Thank you in advance for any help you can give!
Sande