Hi,
How can I filter particular information from specified columns in an excel workbook into separate workbooks that are pre-set with the same column names on the main tab and also with further pre-set pivot tables tabs? I can set up the pivots etc, just struggling a bit with actually getting the data across.

Very simplified example of my main workbook data:

Column A Column B Column C Column D Column E Column F
XXX Company 1 Company 1 XXX XXX XXX
XXX Company 1 Company 2 Company 1 XXX XXX
XXX Company 1 Company 1 Company 3 XXX XXX
XXX Company 2 Company 2 XXX XXX XXX
XXX Company 3 Company 1 XXX XXX XXX

I want to pull the data from columns B, C, D and F into 3 separate workbooks for Company 1, Company 2 and Company 3. The company needs to be picked up from columns B and C and D.
Thanks!