There is only one ActiveCell, not one per sheet. (Actually, there's one per
window, but I assume you don't have more than one window.)

You could activate the different sheets and make a reference  to their
individual active cells, then use those references later.

What are you trying to achieve?