Pull data into a table through Macro

Hi - I have very little VBA knowledge. I am wondering if there is a way to pull in data from a different tab into a preset table? I guess i am looking for something like a vlookup formula, but dont want to enter each resource name manually for the formula to work.

I have list of resources, list of their tasks, and hours assigned to each task. Each resource has multiple rows of data that needs to be pulled into a tabular form. Pivot table just does not look good enough. I have over 100 resources to do this for each week.

Name Task Hours
John Smith Xyz 6
John Smith abc 4
John Smith mno 7
Amy Smith ups 10
Amy Smith tre 7
Ian Smith hjk 8
Ian Smith bnm 4
Ian Smith tre 6
Ian Smith rew 8
Ian Smith ikl 2

Here is the expected output for each resource

Name Task Name Hours
John Smith Xyz 6
abc 4
mno 7
Total Hours 17
Is there a way i can acheive this output? Please help!

Thanks.

Submit a copy of your workbook, or an example workbook, which clearly shows what you want it to look like before and after.

Please see attached for the data and expected output.

Thanks again!