Sorry for the confusion, I was thinking I could get enough info to be able to expand, but realize now it is more complex then I thought. haha

I have attached a sample, The first page is "main sheet" this is the one I will be using to enter data into.

On the "main Sheet" I would like a drop down menu in projects(top of the page) that has all sheets at the bottom "project1" "Project 2" "project3" and so on.

The highlighted parts in yellow is what I would like to pull in from each sheet.

So instead of hitting tab on bottom of sheet to get project, I would just select "main sheet" click drop down menu select "project 2" and all info in yellow from "project 2" would load to "main sheet" then I would be able to enter data that I need and save under new name.

The is is just one section, I would have all most 40 rows of info to cross over, and there is blank spaces between rows.

Hope this better explains, thanks for helping!!!

Attached Files

example project.xlsx (36.1 KB, 11 views)