Hi!!
I have this one workbook, i call the "mothership"... Now i have a few dozen
other workbooks which represent individual cities., for e.g "mumbai" "new
york" and so on... I prepare invoices in each of these city workbooks and
then move the respected worksheet to the "mothership" workbook, so that i
have one place where all the invoices (worksheets) from different cities
(workbooks) are in one place namely my "mothership" workbook. Now in this
"mothership" workbook of mine i have created an "index" worksheet which gives
me information of only a few selected items., say, invoice no., name of the
customer, the total value, the products bought by her etc.. But to get these
i have to copy each individual item., literarily (like a donkey!!) to the
index worksheet. Now what i am hoping to get from you ever so smart and
generous folks [am not buttering :)] is a way whereby the moment i move a
worksheet from say the newyork workbook to my mothership workbook, the data
from there automatically gets updated into my index..... pls pls pls pls pls
pls pls....... helppppppppppp meeeeeeeeeee!!! :(((