Create Summary Sheet with Macro Button

Hi,
I'm working on a spreadsheet that will have the max number of tabs possible of data entry. I'm trying to eliminate as much entry error as possible so a macro button that will automatically fill in the required data for the summary sheet is ideal. Each tab will be the exactly the same size and format.
I'm looking to create a summary sheet that will compile 3 cells (R22C17, R23C17, AND R24C17) of information from each sheet in the workbook along with their sheet name. The entries should be in rows for each sheet. And just to make things a little more complicated I'd love a hyperlink with the sheet name for each data entry (if at all possible).

I've been messing around in VBA with other codes, but nothing this complicated!

Thanks

example1.xls

Thanks for your help! Attached is an example of what I'm trying to do. The 3 highlight cells are what I'm trying to import to the summary sheet along with the tab name.

It works! Thanks for your help!