sheets links

[asad.ermo]

I have more than 25 sheets in a work book , all sheets have same format and headings closing balance at cell F2 . I want put links of all sheets to F2 in a summary sheet

how to done by formula or vba.

[alansidman]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[asad.ermo]

please find attachment

[FDibbins]

See if you can adapt this to your needs...
B2=OFFSET(INDIRECT("'"&$A2&"'!A2"),0,COLUMN()-2)
You will need to fiddle with the -2 at the end to get the columns you want

Note that on at least the 1st sheet, you have leading and trailing spaces in the sheet names - you need to remove those