I have a spreadsheet where I would like to merge the data from two worksheets onto another worksheet - an example file is attached ;)
Sheet1 - this is the worksheet I would like to be populated based upon information from sheet2 and sheet3.
I would like the code to run down the name column (column A) on sheet1 and look on sheet2 and sheet 3 for the same matching name which should also appear in Column A on each worksheet (sheet2 and 3). When it finds the same name on sheet2 or sheet3 I would like to copy the data over to Sheet1 and put it under the column where the header matches where it came from, for example the Age from Sheet2 would put the value under Age in sheet1.
I hope this makes sense, but please let me know if you have any questions, hopefully the attached spreadsheet will help.