Thank you both, Paul and p45cal! I've been able to piece together the information from both of you, and it's almost working as I need it to! Currently, on the other sheets, I'm getting "JobID" in J1, and the sheet name in J2, but I need the job ID in every row of data in column J. (Sorry if I wasn't clear on what I wanted there!) Do I need to add something like a Selection, Selection.End(x1Up)? I've tried a few different things to no avail.

This is what I've come up with so far based on what you've told me. Sorry if I'm not piecing this together right - looping isn't something I'm familiar with. I can usually piece these things together with past posts by others or recording and editing, but not in this case apparently.

Your help thus far has been greatly appreciated! 

Option Explicit




Sub BuildDashboard()
    Dim wsDashboard As Worksheet, ws As Worksheet
    
    Set wsDashboard = Worksheets("Dashboard")
    
    With wsDashboard
        .Range("J1").Value = "Job ID"
    
        For Each ws In Worksheets
            If Not ws Is wsDashboard Then
            ws.Range("J1").Value = "JobID"
            ws.Range("J2").Value = ws.Name
                ws.Cells(Rows.Count, 10).End(xlUp).Offset(1, 0).Value = ws.Name
            End If
        Next
    
        .Columns(10).AutoFit
    End With

End Sub