I have put together 70 sheets of snow plow route cards, I want to pull certain cells from the route cards and list them on a master list that is easy to look at. ie Name, address, notes? I know there is a way but I cant figure it out and its make me crazy.
What I want on the index sheet
<tbody>
</tbody>
What my sheets have on them
<tbody>
</tbody>
What I want on the index sheet
Name | Address | City | Inches | Notes |
<tbody>
</tbody>
What my sheets have on them
City | McCall |
Name | John Smith |
Inches | 6-8 |
<tbody>
</tbody>