Hyperlinks in PivotTable

Hello,

In my own online searching of how to get a hyperlink to work in a PivotTable from the source data, I am coming here for the ultimate help! I have never worked with macros or VBA so I am hoping that someone would be able to provide a step-by-step process for making this type of function work for my purposes (if it can work!)

In my Source Data I have hyperlinks that link to another worksheet in the same workbook.
I would like for my PivotTable to also have these same hyperlinks function (to be able to click on the link and have it take you to the worksheet I have established in the original Source Data link).

Any help you can provide on this is tremendously appreciated!

Please remember - I have not done this before (but am really excited to learn!) so a step-by-step process is so much appreciated!

Thank you!!

Oh and I am in excel 2010!

Thank you again!