Hi. I have a functioning query. Now I would like to be able to do a daily .xls file (same name, same format obviously) and append to the data already there. I'm new to this so any advice or tutorial link or even the best keyword searches would be gratefully accepted.

Here is the M code if that helps.

let
    Source = Excel.Workbook(File.Contents("C:\Users\phillip.gwinn\My Drive\TRANSACTIONS.xlsx"), null, true),
    #"Export Data_Sheet" = Source{[Item="Export Data",Kind="Sheet"]}[Data],
    #"Promoted Headers" = Table.PromoteHeaders(#"Export Data_Sheet", [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Batch #", Int64.Type}, {"From", type text}, {"To", type text}, {"Type", type text}, {"Created On", type datetime}, {"Created By", type text}, {"Item", type text}, {"Serial #", type text}, {"Rec #", type text}, {"SC #", type text}, {"Qty", Int64.Type}, {"Cost", type number}}),
    #"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"From", "Item", "Serial #", "SC #", "Qty", "Cost"}),
    #"Filtered Rows" = Table.SelectRows(#"Removed Columns", each ([To] = "Holding Acct, East Texas" or [To] = "Holding Acct, WestTX") and ([Type] = "From Office To Technician" or [Type] = "From Technician To Technician"))
in
    #"Filtered Rows"
I am not sure if I need to make a new query or if this can be "upgraded" for lack of a better term. Thanks for looking.