Excel VBA Macro - Generate simple report from each line in a table

Hi, I'd like an automated macro to generate readable reports from an Excel table. The source is a diff of tables, where the differences between cells are highlighted. The destination is mockuped in the document attached. I want the Excel macro to act as proposed below : 1. In the worksheet "source", check if each line contains (in any cell) the characters "->" 2. If the line contains the characters "->", create a worksheet according to a mockup 3. In that created worksheet, take the content of the columns "Name" and "Surname" of this line, and put them in designated cells 4. For each cell containing a "->", create a new line in the table of the worksheet, with 4 columns 5. In column 1, insert an ID for the line 6. In column 2, insert the name of the column of this cell 7. In column 3, insert what's on the left of the "->" 8. In column 4, insert what's on the right of the "->" I'm available for any precisions. - Vianney