Append two tabs of data onto new tab using formula

Hi,

I have attached an example workbook where I have three worksheets i.e. ‘Data1’, ‘Data2’ and ‘Master Data’ all of which have the same data format in each column

I have data in the ‘Data1’, ‘Data2’ tabs and was wondering if it is possible to copy the data from both these tabs (using formulas) onto the ‘Master Data’ bearing in mind the rows of data in the ‘Data1’, ‘Data2’ can vary on week to week basis

Any assistance would be gratefully appreciated

Many thanks in advance

Rob


N.B. Excel version 2010

Try

=IF(ROWS($A$1:A1)>COUNTA(DATA1:DATA2!A:A)-2,"",IF(ROWS($A$1:A1)>COUNTA(DATA1!A:A)-1,INDEX(DATA2!A:A,ROW(A1)-COUNTA(DATA1!A:A)+2),INDEX(DATA1!A:A,ROW(A1)+1)))

Copy down and across

ACE_XL

EXCELLENT !! - Just what I wanted, many thanks indeed

Regards

Rob