I want to create a sheet that can show the jobs for each week and who worked on it (multiple people can work on it, due to different departments).
I'm not clear on this.
Are you trying to extract information from many sheets?
You might look into Reports based on Assigned To, date columns, or some other column that will tell you the task is being actively worked on.
Craig
Thanks for looking into this. I want to create a weekyl sheet that contains the name of each employee, and in that row or column add the job he is or was working on (multiple jobs per day).
Do you permissions to create sheets (you need to be a licensed user to create and own sheets)
If you can, then on the Home tab, click "Create New" and select Blank Sheet.
That starts with 6 columns.
Rename the first one ([Primary Column]) to something like Name.
Rename the second one Project
Change the third one to a Date type column and change the name to Work Day.
Then start populating.