prompt user to input # sheets to distribute data from main sheet and distribute data

[rooo67]

Good morning. I need some help. I have to get some data parsed from a single excel sheet to many sheets, in the same workbook. This new number of sheets is dependent upon how many users are input from a prompt. The outcome would move data from the main sheet to n number of sheets based on that prompt. The entire main sheet would be moved into these new sheets, distributing the data evenly. I need to help out some of the other folks on a different team and this would make so many happy. I used to create a lot of macros but have not done it in many years.