Shared Excel workbook, hidden sheets

Hello,

I have a workbook with sensitive data on sheet 1, and sanitised data from Sheet 1 in sheet 2

I have 2 groups of users. Group 1 needs to be able to see all the sheets, whilst Group 2 should only see sheet 2.

Is it possible to have this on a sharepoint hosted excel workbook?

I have tried the Hide function which can be undone easily, as well as VeryHidden on VBA but this hides the sheet for all users rather than just one group.