automating the copying power query results before they refresh

[steve78]

Hi,

i would really appreciate your help with something that i cant work out how to do in an automated way.

i have attached a file to help explain my situation ( please note this is a test file where names have been changed , so the format is crude but the idea is correct )

in basic terms
i have a set of power query tables ( all in green )
and then an Appended table of the results ( this one is in blue ) and this is the table that has the important data that i need, and to copy.

how can i automate ( or program in in some way ) the task of COPYING the whole blue table to somewhere else, and each copy of that data adding to the last copy. ( so basically the blue table ( where it has been copied to ) keeps growing with more blue table data and serves as a history of all the blue table data )

i need to do this copying as the last task, as when i hit REFRESH again, all the data in both green and blue tables will update and overwrite itself.

as far as i understand it, when i hit REFRESH all my tables update AND the blue table updates as well, i wondered if i could add the task of copying the blue table (what i'm asking above) every time i hit REFRESH.

i would be so very grateful if you could come up with a solution, and if there is anything that is not clear , please ask , ill reply straight away.

many , many thanks for your help on this

steve r.

[steve78]

please ignore the blue in colomns A to C, thats some source that i should have deleted.

the BLUE table i am talking about is the one in COL U TO W

tks