I have an excel file which has 35 sheets in it and all the sheets have the same format and same sequence(copy of each other) of data except the source sheet and all i want to do is to update the source sheet and link the 35 sheets with the data in source sheet ...However it is time consuming ....is there any shortcut or vba code for this?

For example Source sheet has 35 values written in column ranging fron Suppose D1 to D35 and i want to enter this amount in 35 sheets ....eg value from Source sheet D1 to Sheet 1 Cell G6,Source Sheet D2 to Sheet 2 Cell G6 up to Sheet 35 Cell G6

Is it Possible to Do all this fastly ? as i am short of time and any help will be greatly appreciated.Thanks