Bring the random column value form another table into current table in power BI

Above Excel sheet total 4 sheet 1) Output 2) TH-Template 3) CK_Template 4) USPA_Template.
Above image Showing Column A9: sheet2 with name TH-Template,  Column A10: sheet3 with name CK_Template, 
ColumnA11: sheet4 USPA_template. 
Column A9 with yellow background , Column C9, Column D9 with green background it showing: sheet2 with name TH-Template inside column B2 value and column G9 value. I want this value into  OutPut Sheet and value must replace with replace from TH-Template sheet column B2 value and column G1 value with OutPut Sheet column C9, Column D9. I want this in Power BI with Edit Query. Is it Possible in Power BI?