title: VBA to autofilter in a specific column for each criteria and copy the result to a new sheet
body: <p>Could you please help in automating the below task through VBA.</p>
  
  <p>Need to filter on each region (Column F) and copy the result to a new worksheet. would be helpful if this can be done through looping as the original data set contains more regions. Thanks for the help</p>
  
  <p>Column F (First 10 cells): East west west North South East South South West North</p>