I attached a spreadsheet that has serial numbers on the first tab and matching serial numbers on the next tabs. I am looking to pull specific information from the subsequent tabs and copy that information to the main page.
In the example, I am looking to pull "Contract Start Date" information from the other tabs and copy that information to the main page. So I want it to find the "Contract Start Date" and copy the cell to the right which has the date and place it under the "Contract Start Date" column on the first page. The "Contract Start Date" on the other tabs may not always be on the same row so there will have to be a way to find the data regardless of where it is located, thanks in advance.
Bookmarks