Ok gotcha. My G9 can do focus bracketing (like what you describe) but it also does focus stacking in camera which produces a jpeg with mixed results so I don’t use it much.
This thread may help you in your Stacking journey -
I use Zerene and so do a few other folks here on NPN, but Helicon Focus is another dedicated stacker that will do a better job than Photoshop.