Manually Adding to Reports

I'm looking for a way to pull information from other sheets, while also being allowed to manually add data. The reason I'm doing this is to allow for staff to go to one place where we can share individuals goals, tasks and progress. Is there a way to do this?

I have tried formulas, but I do not believe it updates when that individual is assigned to a task on another sheet (which is the benefit to a report).