Hi Experts,

I really need your help. The requirement is given below:

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 with fresh data very often. So, I need to get the data from workbook A(sheet1) into workbook B(Detail_data).
Could someone please help me resolve this issue.

Thanks in advance,
Regards,
Preethi.