I am curious is this is possible:

I have a workbook that I use for keeping track of
inventory. Each worksheet is for a different department,
and the inventory for that department is contained in that
worksheet.

The worksheets are simple. Each contains 4 columns: Part
Number, Description, Quantity, and Location. Each
worksheet's data is sorted descending by part number.

I want to know if I can create a worksheet at the
beginning of this workbook that would allow me to enter
data, hit a button, and have it stored on the correct
worksheet and have the data resorted. I would like to do
this to save time sorting through worksheets and resorting
data.

Thank you.