I have pretty extensive sub programming experience, but I've had only modest
success writing custom functions as they take slightly different parameters.

I have a workbook with several tabs, one for each month (Jan 08, Feb 08,
etc), and an output tab. Each tab contains a report of the total payroll for
each of up to a few hundred employees for that month. I need the output tab
to be a pivot table of sorts, with each employee's name and number in rows
down columns A and B. I want columns C, D, E, and so on, to output the net
payroll for each employee for each month. I have a complex string of a
vlookup that does that already in place, but I have to change the vlookup to
the appropriate month as well as build into it several if(isna()) functions
to return a 0 if a given employee has no payroll in a given month. I would
like to build a custom function that will look something like this:

Function LookupPay(EmployeeNumber as string, MonthTab as string)

I'm having trouble finding the correct syntax that will take the MonthTab as
an imput and use that to designate the correct sheet.

Any help would be greatly appreciated.