I am trying to create a summary table for information found on another
spreadsheet. My main spreadsheet contains data for all of our staff, what I
would like to do is create a summary table by staff member. In my summary
table column A will contain the staff members name. On a seperate sheet,
column G contains the staff members name and column L contains the
information that I would like to sum.

For example I want to add all the numbers in column L for if the name in G
matches that in A from my summary table. Can anyone help?