auto transfer specific values to new worksheet?

[fearziz]

I need to transfer specific values to specific worksheets after they are imported from a SQL datasource. Issue is that the data is in the same table and is imported as shown below. I just need each value with the exception of value#1 to be moved to a new worksheet so that I can calculate growth. I would have a total of 5 worksheets if this is doable..and I would prefer that it occur automatically after selecting "refresh all" for my SQL datasource. Alternatively I could add a button if you know how to tie all of this togethor. Is there anyway for me to do this? I'm novice with excel!

COLUMN1 COLUMN2 COLUMN3
2014-09-20 424800335 value#1
2014-09-21 188584320 value#2
2014-09-21 425019591 value#3
2014-09-21 9541616 value#4
2014-09-21 1698233735 value#5
2014-09-22 188693826 value#1
2014-09-22 425181482 value#2
2014-09-22 9542993 value#3
2014-09-22 1699389521 value#4
2014-09-22 425181487 value#5

[davesexcel]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[simcode]

don't know if this is u want. i hope it can help.