Hello Experts,

I am trying to call a workbook with a single worksheet into another
workbook's detail_data worksheet.

I have 2 workbooks: Workbook A and Workbook B.
Workbook A has only 1 worksheet (Sheet1) and Workbook B has 7
worksheets.
In Workbook B, the is a worksheet called "Detail_data" where all info
is stored. All the other worksheets in Workbook B , contain pivot
tables that must change as per data in the Detail_data worksheet.
Also, Workbook A is refreshed everyday with fresh data.
So, every time, I open Workbook B, and click on a button(may be a
refresh button), I must get the data from Workbook A (sheet1) into
Workbook B (Detail_data).

I did try using the "Indirect" reference method, but somehow, I'm not
able to solve this.
Could you please help me resolve this issue.

Thanks a lot in advance.
Regards,
Preethi.