Macro/Automatic script that scans for certain values.

I'm not exactly experienced in Excel or VB so this one is slightly challenging for me and I can't find a way to easily execute this either through a macro or automatically.

I have a time sheet for employees, we manage four venues in the same building, what we need to happen is we fill out a time sheet and depending on a cell in the sheet it will then take that person's position and sort it in to an area on another sheet that separates per venue and only creates one entry per employee that works in that venue throughout the week.

I've attached the spreadsheet so you guys can get an idea of what I'm looking at.

I'm not looking for someone to do the work for me, I'm looking for people to give me a shove in the right direction on where to start this.

Thank you all for the help,
Ikith

Bump...

Anyone at all?