Need help qith formula

I am trying to get my spreadsheet to automatically take records from one worksheet (titled All) to other tabs based on the contents of a column (Department, column H) The workbook is laid out with an All tab and a dozen or so Department tabs. If I have a record (Model Number, Item Name, Inv Count 1-4, Total, Department, Category, Family) on the All tab I would like all the data to automatically copy to the specific Departments tab (ie if cell H2 = Appliances move the contents of A2, B2, C2, D2, E2, F2, G2, H2, I2 and J2 to the corresponding columns, not necessarily the corresponding rows, on the Appliances tab.) The maximum row the departments could actually fill down to on the All tab is 2501. I'm sure it should be a vlookup formula but I can't figure out the syntax I should use.

Here is the pertinent information (column headings and tab names)
Column Headings

Model
Description
Count (merged over columns c,d,e & f but no digital data will ever be in these cells, for handwritten data when printed)
Total (no digital data will ever be in this cell, for handwritten data when printed)
Dept
Category
Family


Worksheets

All
Appliances
Automotive
Bed & Bath
Books & Software
Clearance
Electronics Acc.
Fashion
Furniture
Home
Home Decor
Home Office
Houswares
Luggage
Personal Care
Photo
Seasonal
Sports & Recreation
Telephones
Tools
Toys

Thanks in advance for any help you fine folks can provide

-Dave