如何使用VBA在Excel中添加新工作表？

I am new to VBA coding. I want to populate an excel sheet with different data. The requirement is to pull data into separate sheets of the same Excel. I need to use the same type of code below to maintain the integrity of the entire code.I am new to VBA coding. I want to populate an e