COPY MULTIPLE SHEETS INTO DATA
I am building a database where I Currently have several macros.
At the moment, the macros in use are perfect however I need 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 !