the format for referencing other worksheets is

='HH1'!B2 use the single ' and the explainattion !
='HH2'!C4



"Sanj" wrote:

Hi,
I have a excel work book that consist of sheets HH1 & HH2
I would like to merge this two to get a summary sheet. I would not like to
cut & past information to Summary sheet.
Can someone help me to do this pls.