How do i link a data from different sheet on a summary page automatically

[Nurul]

Hi all,

I am trying to tabulate a report of my colleagues spending hours on completing a task on a daily basis.
With different accounts for different colleague on daily basis, how do i make it easy for the summary to capture the report without having to link it manually.

i tried index and match, but cant seem to have it auto.

thank you in advance