I have been tasked with linking about 30 workbooks with 1 worksheet
each to one master workbook. We work different shifts and they want to
be able to get the data even if someone isn't here. Currently we are
copying and pasting the data. I was going to do a macro until they
told me about getting the data from a closed workbook. I haven't done
VB in years so I am quite stuck, any help is greatly appreciated. I
have already tried to convince them to use access and then I could
just do a sql script for them to do the reports but that didn't work.

Maybe this link can help:

http://www.ozgrid.com/VBA/ExtractFromClosedWorkbook.htm

"poemagic" wrote in message
...
I have been tasked with linking about 30 workbooks with 1 worksheet
each to one master workbook. We work different shifts and they want to
be able to get the data even if someone isn't here. Currently we are
copying and pasting the data. I was going to do a macro until they
told me about getting the data from a closed workbook. I haven't done
VB in years so I am quite stuck, any help is greatly appreciated. I
have already tried to convince them to use access and then I could
just do a sql script for them to do the reports but that didn't work.