There are many sorting options within Excel. However I'm
trying to create a macro, that when executed will take a
small range of values in a column in one "tab / worksheet"
of a workbook, clearing and moving the contents in a kind
of initialization action. The purpose for this is to
create a year-to-date population section of a saved file
using information from similarly formatted files
worksheet's.

Also, I'm trying to set up a way to sort (from a main
input page) a list of data containing descriptive jobs
followed by columns with categories, departments, spending
etc. I would like to import each line item if a specific
category or department input is met. This data will
then be copied and put into named "tabs / worksheets"
corresponding to what category or department was sorted
for from the main input list.

Thanks