Can you change a source in power query for excel?

[Mr_Phil]

Hello I am taking baby steps to learn power query. The big project for me is to do in power query what I used to do via the macro recorder. I have a query with the source a sheet in another workbook. I copied the sheet to my new workbook but I don't know how to change my source from:

let
    Source = Excel.Workbook(File.Contents("C:\Users\phillip.gwinn\My Drive\SCORECARDS\Copy of RA SCORECARD WORKSHEET.xlsm"), null, true),
    FEEDBACK_Sheet = Source{[Item="FEEDBACK",Kind="Sheet"]}[Data],

Just the feedback sheet which is now in the same workbook as the query.

If this is any easy fix I appreciate the help. If it is complicated I would appreciate advice on a tutorial or website where I can work on learning what is needed. No matter what, thank you for your time reading this.

 

[alansidman]

If your data is in the current workbook and you wish to bring in a table/range, then here is the Mcode

   Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content]