I know this question has been on here before but I cannot seem to "translate" the code from others to my workbook. I have always been able to get by with formulas rather than code but for this task it seems to be unavoidable.

I have a catalog of parts that are rarely used and we store in containers. I want to be able update the "master list" and create new sheets for each location, as of right now I have a total of 6 locations (HOC I - HOC VI). All sheets will have identical headings A1-F1 and D will have the location.

Here is a list of all my headings:
A - Part #
B - Description
C - Quantity
**D - Location
E - Skid (location details)
F - Comments


Thanks in advance for any help!!
I may want to add columns in the future but I will still want to extract data by location.