create masterworksheet from different workbooks and update when values change

  • Hi.


    I have 4 workbooks in different folders with 3 worksheets named A, B and C. All workbooks have these 3 worksheets.
    I want to create a masterworkbook where all workseets A are merged into a Masterworksheet A. The same for B and C. So I will get 3 masterworksheets in a masterworkbook.


    Also when a record is added or changed in the worksheets, this should update the corresponding masterlist automatically
    the idea is to protect the masterworkbook so no one can edit this. Changes can only be made in the worksheets.


    i'm new at excel VBA. So if someone can help thanks!