Populating Multiple Columns and Rows based on number of sheets

[hartjonathand]

Hey guys,

I think I generally have an idea of what I'm doing on populating columns in multiple sheets, adding data from other sheets.

My question is related to being able to insert rows based on the number of worksheets in the workbook.

Thinking about this the process would be

Count the number of worksheets
For each worksheet i in workbook
add a row starting at row "a"
iterate until populated for first matrix

repeat for matrix below.

Thanks all.

 

[Fluff]

Not entirely sure what you are after, but this will insert as many rows as there are sheets starting in row 2

Sub hartjonathand()
   Rows(2).Resize(Worksheets.Count).Insert , xlDown
End Sub