I've written a code to bring in data from multiple worksheets and display it onto a summary sheet. (Thanks to all of the code examples on here by the way, they are invaluable for self teaching VBA noobs like me).
The code clears the data sheet of all data bar the headers then brings in...