I have an excel workbook with 17 Sheets.
On each sheet Column "A" list of names, Column "B" has a value that varies.
On some days there are more names in Column "A" than other days.
In the results Worksheet, I need to lookup the value in cell "A1" across all worksheets Column "A", then return the Maximum Value in Column "B" for that entry.
Any assistance would be greatly appreciated!