Create your new workbook ('a'). Copy the data in 'b', plus as many blank rows and columns as you think will be filled up eventually. Then just Paste Special- Paste Links onto the sheet in 'a' where you want the data to appear. Do the same for all the other sheets. You can copy entire sheets in this way, but it usually leads to a very large workbook. Hope that helps.
Like this thread? Share it with others