I have three worksheets of data that I need to combine into one worksheet based on the data in column A, the ID column. In my example, If there's an ID row with data in worksheet 2016, those 4 rows of data need to be copied over into the 2016 section of the Combined worksheet. I think I can do this with vlookup, but I'm not sure how to tell Excel to copy the entire row over as opposed to just one cell. I need to do this for every year sheet.
Thanks for any guidance!
