Copy Column From All Worksheets & Create 1 List

I have the below code, I want to end up with values in column 'A', and a hard coded value in column 'B' for each row in column 'A'. But, I'm ending up with the hard coded value just in the first row of column 'B'. In other words, I want to repeat a value and copy it down column 'B' the same number of times that there are values in column 'A'. Here is what I am working with so far that is producing just the value in the first row of column 'B' -

Private Sub dispnames()
Dim b As Integer
Dim r As Integer
Dim sh As Worksheet

For Each sh In ActiveWorkbook.Worksheets