Select Cells from Column A which are hyperlinked to Sheets

Hello,

I would like to do the following:

1.Select Cells from Column A in "Index" Sheet which are already hyperlinked to Tab Sheets in the current workbook.

2.If the sheets in Column A of "Index" Sheet can be selected then, the selected sheets needs to be saved as a separate workbook.

3.The destination of workbook then needs to be saved in the last line of Column A of "Index" Sheet.