Merge Sheets Power Query

Hello All,

I am trying to merge 4 sheets into one using common columns for each unique row.

See attached.

These queries are retrieving data from a files on my HD. I added columns "Count" and " Unique BN" to give each row a unique value to avoid duplicates.

I have highlighted the following columns as common columns:

Total Amount
Date Requested

My hopes was I could use the power query append to slam these together and put them in all of the unique rows into one sheet.