Can you open the three workbooks manually from whatever computer you want to
use? If so, turn on the macro recorder and open them manually. then copy
the data you want into you consolidation workbook.

Then look at the code you record and modify it to suit your needs.

--
Regards,
Tom Ogilvy


"choice" wrote in message
...
im starting from scratch and not sure how to begin:
i have 3 workbooks; register1.xls,register2.xls, and register3.xls. i want
to be able to import values entered from register 1 2 or 3. into
data.xls.
register 1 2 and 3 are on seperate computers, but are networked. any info
would be GREATLY appreciated. thank you in advance