File merging in Excel or R studio

I have some .xlsx format files to merge in R programming language / R studio or can be done in Microsoft Excel and create few new tables from merged table. I will tell you how new tables should be so you don't need data entry or data analysis, all you need to do is merging tables and create new tables by filtering the main table.