I am a civil engineer. I use excel to sort out different areas, setbacks, and various information for each lot. I have all of this data on 1 sheet by lot number. I am wondering if there is a way to have all of this data be seperated into individual sheets. Ex. All of lot 1's information would create it own sheet automatically and copy all information related to lot 1 from my main sheet to the new sheet. And then it keep making sheets for the rest of the lots. Is this possible and if so what would I need to do?