I need to gather some counts from a worksheet and return
them to another sheet.

Workbook #1 Sheet 1 RC A3 is to hold the totals from
Workbook #2 Sheet 1 RC to be determined by inspection.
This calculation should occur when Workbook #1 is opened.

I have the code necessary to find and calculate the
totals in a worksheet_activate sub for Workbook #2 Sheet
#1, but can't get it to be triggered without manually
opening the sheet, then clicking in another sheet, then
back to the 1st sheet.

What events can be triggered by just opening Workbook #1?

Can you assist?
Thanks.