Autofill or link data from one tab to other tabs in Excel 2010

[AverageJExcel]

Looking for a way to track my employees. The attached spreadsheet is a work in progress. I'm an average excel user, not afraid to work through something or teach myself. Any help on formulas or feedback/guidance/coaching is much appreciated.

1)Ideally, I would like to add a new hire to the "Hire" tab and then have that individual and their info auto-populate and stick with them throughout the entire spreadsheet or on the "Attendance" tab. The attendance tab is basically a point system tracker with points falling off after 6 months from the infraction.

2)When they are terminated I would simply cut from the hire tab and paste them to the term tab. Which would remove them from the attendance tab and the pfp tab.

3)I would like the names of those listed as hired to populate on the "PFP" tab. This tab is a performance metric that is manually inputted by me and calculates a score. I would like the score in column P to stick with the individual and auto populate for the individual in the attendance tab column G.

Basically, so that I can review an individuals score and their attendance points. In the end I would like to some sort of pivot tables or graphs to show on the dashboard tab those with the most attendance infractions, lowest scores, etc.

[protonLeah]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)