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)

Is it like this?

Attached Files

pull_data_2.xlsx (11.2 KB, 16 views)

works like what you have done, I have attached my example on last one not sure if your able to use that. are you able to share the steps I need to do

Sorry, I happened to attach the wrong file.

The formula =INDIRECT("'"&$C$2&"'!RC",0) takes the value from the same cell (as where the formula resides) from the sheet specified in Main sheet!C2. The formula assumes that all sheets have the same structure.

Attached Files

example project_2.xlsx (36.5 KB, 13 views)