How to link dozens of cells in multiple tabs to the same cells in the source tab

Please excuse my ignorance for Excel. This is likely a simple question.

I am working on an Excel file with multiple tabs with the exact same structure. I need to have the same cells in multiple tabs refer back to several cells in the source tab. What is the quickest and easiest way to do this?

For example, there are values entered into cells into D61, D68, D75, D82, D89, D96, etc. in the source tab. I need several other tabs to show these same values, in the same cell locations. How do I do this without copying and pasting the link to the source tab into every cell location which I think would be incredibly tedious. Because there is space between the cells I can't just copy and paste into the other tabs.

Please help.

You can group all the multiple sheets together, which has the advantage that whatever you do in one sheet is automatically repeated in all the other sheets which are grouped. So, assuming your source sheet is positioned on the extreme left of the tabs at the bottom of the Excel window, click on the next tab then hold the <shift> key down and click on the final tab, then release <shift> (you may notice that the colours of the grouped tabs change slightly). Then you can enter this formula into cell D61:

=source!D61

Then click <copy> and paste that formula into cell D68, then D75, then D82 etc. When you are finished, just click on the source sheet tab to ungroup the sheets.

Hope this helps.

Pete

Thanks Pete. That worked perfectly.