Hi there! I really need your help. Is there a macro that could do the following:

I have a worksheet full of formulas (sumifs, index(matches), etc). These formulas pull from 4 worksheets of source data in the same workbook.

What I want to do is that if a user double clicks on any cell with a formula, it will open up a new worksheet and will display only the source data that was used to calculate that number (similar to what pvt table does)? The reason I don't want them to see all of the data is because various users have different rights to what they can see.

Thank you for any help!