If the 'destination' workbook is simply a duplicate of the 'source' workbook, but with different formatting you can link the data in each by way of formula.....e.g. open both workbook and in the destination sheet, cell A1, hit = then switch to the source workbook and click on cell A1 then enter. The formula will look something like this =[Source.xlsx]Sheet1!$A$1
You would then simply copy the formulas down / right and when opening the file you will be prompted to update links, which you would say yes to get the latest data.
