Violet,

Assuming all your monthly workbooks are laid out the same such that all data
is in the same location (just different data); then do this:

1. On your main workbook link all applicable cells to, say, Temp.xls
2. Load your monthly workbook template and Save As Temp.xls. Replace the
existing file.
3. Update links.

Don't ever delete temp.xls when your main workbook is open or all your links
will #ref. Just replace the Temp.xls with new worksheet templates for each
month.

You can do this under VBA control very easily by just recording macros.

Allan P. London, CPA





"violet" wrote in message
...
i have a workbook(main) which is suppose to display data from various
workbook. however, every month the workbooks(various) will be in different
location and there will be additional data. so hw can i link all these
data
to my workbook(main).

note: Additional data will cause the column of my required data to change.