Plot Data from one sheet to another and total time

[Forest_Girl]

Hello Gurus. I am a newbie to VBA and I am in need to a macro that will fetch data from a sheet to another.

Here is my input sheet:

and here is my output sheet:

Notes:

• Total Request = Sum up all requests (Closed/Completed/Resolved, Open, OnHold, Discontinued) EXCEPT for "IN PROGRESS"
• In Progress = Sum up OPEN and ONHOLD
• Request status that are not labeled as (Closed/Completed/Resolved, Open, OnHold, Discontinued, In Progress) should be disregarded. (e.g. [PR], [CR])
• Total all Time Spent.

Please, please, please help meeee