Macro to Sort Based on order of a different sheet

I have two workbooks that i need to have the order of the rows match. The first workbook is a log book that is typed in by staff. Each row is a new patient visit. The second workbook is a file that is generated from a program that is sorted by just the date; so the actual order of the patients is wrong. I need the second file to be in the same order that the log book is. The log book has a "visit number" for each patient. I tried doing a vlookup to pull the visit number for each patient and sorting it that way, but some patients have more than one visit in the month. I need this to be as simple as possible and they need to stay as two separate workbooks. If there is a better way to do it rather than using a macro, I am open to that as well.

Thanks in advance.