VBA trigger action after data from other sources are refreshed

Hi guys,

is there a way to run a procedure after data from other sources (MS Query/DB) are refreshed?
I set the property for this connection to "Refresh data when opening the file".

I want to copy some part of this data to another worksheet, so I have added code to the ThisWorkbook object.
Procedure is fired after opening the file, but before the data are retrieved from DB. So it copies nothing...

Thanks

Private Sub Workbook_Open()
    Worksheets("Test").Activate
    Worksheets("Test").Range("A1:V500").Value = Worksheets("ORQData2").Range("A1:V500").Value
End Sub

Thanks, did not not this can be done.