Combine data of 2 sheets to one sheet with one condition

Hello experts
I want to combine the data of 2 sheets which are in another folder and get the result in the source workbook where the button is situated in the 2B Combined sheet. There are multiple folders in the source folder where the data is to be derived. There is a condition to be added in the code. The data of B2B sheet to be copied as it is and the data of B2B - CDNR to be posted in the required columns with negative amounts. The code in the workbook was shared by Marc L which had multiple conditions but in this project This is for reference purpose only. I need to apply only the above condition. I need all the rows in both the sheets. Rest is explained in the steps sheet.
Thank you in Advance
The 2 sample xlsx sheets are saved in a folder named 2B Folders and saved on the desktop.

See attached: B2B Combined

Thanks John Topley. Just one column to correct in the destination sheet. Column I Rate is the percentage of tax and not amount. I want the value of that cell to be positive in the result.(Derived from B2B - CDNR sheet in negative values). You can tell me which line to edit. Sorry I also want to remove the lines printing W and X completely.

Please Login or Register  to view this content.

How do I edit this to avoid changing column I to negative.?

I was able to solve the column W and X by commenting these 2 lines. But to avoid the Rate column values from changing to negative is a little tough.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I simple changed the filter constant in Marc's code to be a "wildcard" so that as far as I will go!

Please Login or Register  to view this content.

Comment out ...

Please Login or Register  to view this content.

Still I am not able to avoid the Rate % column from converting to negative.
Will try again tomorrow. Thanks John Topley. Good Night.

Try ....

Please Login or Register  to view this content.

That is the same line in the code. It is showing negative values in Rate column whereas I want it to show positive.

Not if you make it a COMMENT!

If I comment it only the column 6 is showing negative figures. I need negative figures in columns 10 to 14 too. I think I better go with that line as it is showing only one negative figure in the Rate% column untill these lines are corrected and resolved.

Please Login or Register  to view this content.

try

Please Login or Register  to view this content.

The edited code in post#13 worked perfectly. Thank you John Topley