i would like to write a code that creats a table of content.
So the code would take the value of B1 on each sheet, and copy it in a new sheet called Table_of_Content.
Here is what i wrote so fare but it doesn't work:
' Creating table of content
Dim work**** As Worksheet
Set work**** =...