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.