How to Move Data in Excel

[smogsy]

Firstly, i did know how to do this at one point but i haven't touched excel in years & wants to start learning again.

Heres what i want to do not sure how to do it
In Sheet1 there will be many field one being "Model" (which is a column)

Now in Sheet 2 there are grouped section for each "model" (which are in row format) with the same fields. this sheet is an overview.

what i want to is:
Move the data from sheet 1 to sheet 2 depending on there model (the entire row)

for example Sheet 1 one model could be be: LE453BMX - this would automatically (or by a button update) copy itself to Sheet 2 in the correct section.

how would i go about doing this?

 

[smogsy]

Ok, i had to change the data/field a little as its for work.

See Link below for the execel file
www.smogsy.co.uk/work.xls

just the clarify:
i want to somehow search Sheet1 B Column for certain Model then copy the contents of that row to The correct area on Sheet2 & repeat for each section

 

[smogsy]

thanks for the big help skeeny, it worked at work on my machine but not on my bosses. were looking into to that atm seems hes missing a DLL!.

thank you again for the time you put into this, once i get time i will be modfying it to work exactly how we want it and with the correct data not fake data like what was in the execel sheet