Ok, so I think there are a few steps involved:
- Moving the individual job sheet files to the master list file.
This is done by right-clicking the sheets tab, click on 'Move or copy', select the master list file from the drop down list (master list file must be opened for it to appear) and click OK.
- Renaming the sheets and transposing the data to the master list sheet. A single transpose action will not be possible because of the merged cells.
Dim ws As Worksheet
Dim x As Integer
x = 2
For Each ws In Worksheets
If ws.Name <> "Master" Then
ws.Name = Range("B11").Value
Sheets("Master").Range("A" & x).Value = Range("B4")
Sheets("Master").Range("B" & x).Value = Range("B7")
Sheets("Master").Range("C" & x).Value = Range("B9")
'Finish this list for the rest of the data
x = x + 1
- And finally print the entire file.
Can you work with that?