Retrieving the last selection of inactive sheet without activating it

Hi

I'd like to create a report based on selection of multiple sheets.
Now I catch the active sheet of the active workbook and I activate it back at the end.
But because of the activation (= jumping among) of several sheets the users are a bit confused.
Do anyone have a good idea how to retrieve the last selection of any inactive sheet without activating them?

Thanks

Thanks

it is really useful