Each employee has a separate tab in the spreadsheet with their own details in
it...I'm trying to put together a separate tab that has a one line summary
for each employee. The separate tabs have the employee name as the tab
name...can I use the employee name (generically) in column A in the summary
sheet in a formula to pull info back from each employees detailed sheet ?

I want the summary sheet to look something like this:

Employee Name Annual Allotment Total Points Incurred
Smith, Joe 12 0

with the annual allotment and total points incurred being formula driven by
looking up the info from the employee name listed....how do I use "Smith,
Joe" generically (column A, row ##) in a formula to grab data from specific
cells a separate tab named "Smith, Joe" ??

Does that make any sense ?

Thanks for any advice !