copying dynamic range & few multi cells from multiple sheets to summary sheet

[ansvk1]

Hi there,
i have recently realized how much fun & time saving it is to use VBA macro writing for reporting purposes. i am an operations analyst, and would like to automate all my reports (if i could).

I need help writing a macro to pull in info from multiple sheets with each #ed sheet's multi cells and a bunch of associated error findings cells into a new Summary sheet.

My spread sheet looks like this:
I have a report (175 sheets) with most sheets named as numbers (starting with 2,3,4....150-& could increase sometimes). each numbered sheet has bunch of applicable data on top, and few rows of variable count "findings" on the bottom (another bunch of data). not sure how to insert a pic here .

sheet 2, 3, 4,....150 or maybe more
data on top half of sheet
Column D Column H
loan # Loan type
borrowwer first name address
borrowwer Last name product name
Loan officer Loan term
processor interest rate
Closer
appraiser
application date

data on bottom half of this sheet

error level error code auditor comments responsible initial
3 1501 asdfasdfsafdas Jack agree
2 0123 dsfasdsdagd Joe disagree
4 1102 sadfasfadfsa Lee change of case
.
.
.
sometimes 3, 4,5,6,...20 dynamic rows count.

Here is what i would appreciate some help with:
I need to copy all the data on the bottom half, to sheet "Summary", already present (x rows, starting from 2nd row) and all these x rows needing to pull in only bits of same data on the top half pasted on each x row adjacent to bottom data pasted earlier.

Loan# Loanofficer processor Loantype Loanterm errorlevel errorcode auditorcomments responsible initial
. 3 1501 asdfasdf Jack agree
. 2 0123 sdsdagd Joe disagree
. 4 1102 sfadfsa Lee change of
.
.
.

thanks,
Krishna

 

[ansvk1]

Dear experienced members,
kindly guide me on how to more clearly present my problem to get a quick and better answer from vba experts.

thanks for your hlep!
krishna