Move sheets to master sheet

  • Hello All,


    I work in risk management and I am currently building a database where I Currently have several macros.


    At the moment, the macros in use are perfect however I need a further some vba which feeds 4 separate sheets into the one data sheet.

    The 4 sheets for example are: “a”, “b”, “c” and “d”

    And the data sheet it called “data”.


    All 5 sheets have the same column headings, so should be easy when copying over.


    The main emphasis of this VBA is to just add to the existing sheet as new items get added to each Of the 4 data sets.


    Please can you help, it would be much appreciated! I am tearing my hair out !

  • Jack W - the rules are here:-


    Forum Rules


    Why have you got 5 sheets of identical data?


    Try this


  • royUK

    Changed the title of the thread from “Hello All,” to “Move sheets to master sheet”.