how to read multipleexcel files with all sheets at once.Column names are same in each sheet.?

Sorry but I don't understand your question, you have said that al sheets have the same column names, so what you're saying makes no sense to me, could you please clarify?, ideally, could you please prepare a reproducible example (reprex) illustrating your issue? Please have a look at this guide, to see how to create one: