Macro to update Aging Report

Hello,

I need your help in creating a Macro for preparing a Aging Report.

In the sample sheet I have Raw Data sheet and in that it has to look for Close time column and if it is empty it need to copy the data in another sheet named Aging Data (As in sample sheet).

I need the Pivot table as shown in the sample data and in that I have added Column H & I using today () function & below code manually. Please help me to automate it.

=IF(H4<=3,"0 to 3 days",(IF(AND(H4>=4,H4<=7)," 4 to 7 Days",(IF(AND(H4>=8,H4<=15)," 8 to 15 Days",(IF(H4>15,"> 15 Days","")))))))

Note: The data is not constant and vary.

Thanks in advance for your help!!

Regards,
Humac