How can I consolidate selected tabs from multiple workbooks into a single workbook?

[kartickn]

There are about 10-12 workbooks in various network drives which get updated at a given point in time on Mondays. I would like to:

1) Selectively import values only versions of tabs into a single "master" workbook.

2) Have the system be portable enough so that when a new tab is added or deleted, I do not have to touch the actual code.

Is there an easy way to do this? Help is greatly apprecicated. :)

[Hack]

Moved to Office Development

[Webtest]

1) Selectively import values only versions of tabs into a single "master" workbook.Could you explain a little more or give an example? I don't understand how you are going to determine which worksheets to copy.