Prorate costs based on month across sheets

[wudaben]

Hello,

I'm looking for a little help figuring out how to perform the following functions. Currently I have "Sheet1" showing me the following data:

Test.xlsx
	A	B	C
1	Name	Computer Name	Start Date
2	Joe Blow	Computer1	1/1/2020
3	John Doe	Computer2	3/15/2020
4	Jane Smith	Computer3	4/1/2020
5	Jane Doe	Computer4	4/6/2020
6	John Smith	Computer5	4/15/2020
Sheet1

I would like to have Sheet2 automatically display the prorated costs for each user sorted and totaled per month similar to this:

Test.xlsx
	A	B	C	D	E
1	Jan-20
2	Name	Computer Name	Monthly Rate	Start Date	ProRateAmt
3	Joe Blow	Computer1	$26.00	1/1/2020	26.00
4
5				Total:	26.00
6
7	Mar-20
8	Name	Computer Name	Monthly Rate	Start Date	ProRateAmt
9	John Doe	Computer2	$26.00	3/15/2020	14.26
10
11				Total:	14.26
12
13	Apr-20
14	Name	Computer Name	Monthly Rate	Start Date	ProRateAmt
15	Jane Smith	Computer 3	$26.00	4/1/2020	26.00
16	Jane Doe	Computer4	$26.00	4/6/2020	21.67
17	John Smith	Computer5	$26.00	4/15/2020	13.87
18
19				Total:	61.53
Sheet2

Cell Formulas
Range	Formula
E3,E15:E17,E9	E3	=C3*(DAY(EOMONTH(D3,0))-DAY(D3)+1)/DAY(EOMONTH(D3,0))
E5,E11	E5	=SUM(E3:E4)
E19	E19	=SUM(E15:E18)

Is this possible? The formatting doesn't have to be exact and if there is a better method for doing this please feel free to change the data around however. Basically I'm currently having to manually total the users for a particular month and apply the formula and I'd prefer to automate it so that other users do not need to make and changes to view the data.

Thanks for any assistance you can provide!