Let name both workbook as A and B the worksheet in A as Summary and the
worksheet in B as 1 and 2. Worksheet in B is a form and at time it may
contained
worksheet up to 100 or more but the designed is the same.

After completing all the worksheet in B, I would required to transferred all
the data back to A and currently what I did is using = enter, which is very
time consuming especially when B contain too many worksheet.

Using my method, the cell A1 in A worksheet would reflected as
='[B.xls]1'!$H$15 and cell A2 would reflected as '[B.xls]2'!$H$15 and so on
for the rest of the cell in A