Summary Tab of Multiple Sheets

[Excel1991]

I have to create a summary sheet of approximately 60 worksheets. Luckily all of the worksheets are the same format so when I do the summary tab I am linking the same cell across all the worksheets.

Are there was of linking the cells to the summary tab without having to go to each cell on a tab and linking it individually?

Thanks

 

[IbrahimAnjum]

Select the ones you want linking to the same sheet and replace all, then select the next bunch and repeat