I have a microsoft spreadsheet with 150 sheets in it labelled by the day and date, all same format just different input figures.
I need to create a master sheet which pulls specific information... about 36 figures from each sheet).
I manually selected by equation what figures I want to pull across for the first day, however I'm unable to duplicate it for the other days.
I've created a spreadsheet which has the names of each of the 150 tabs in it for ease. I've attached an example of the summary sheet. I need to be able to create a pull down so that it automatically completes when the other tabs are filled in.
Evaluating and Writing Personal Biography Category: Biography Writing, Book Design, Book Marketing, Creative Writing, Ghostwriting, Publishing, Research Writing Budget: ₹1500 - ₹12500 INR
24-Dec-2025 05:04 GMT
Reliable Social Media Video Producer for Short Clips -- 2 Category: Adobe Premiere Pro, After Effects, Audio Editing, Color Grading, Final Cut Pro, Video Editing, Video Post Editing, Video Processing, Video Production, Video Services Budget: $30 - $250 USD
Product Development & WA Marketing Category: Facebook Marketing, Product Design, Product Development, Product Management, Research Writing, Social Media Marketing, Twitter Budget: $15 - $25 USD
24-Dec-2025 05:02 GMT
15-Second Instagram Sales Ad Category: After Effects, Animation, Instagram Marketing, Motion Graphics, Video Ads, Video Editing, Video Post Editing, Video Services Budget: ₹600 - ₹1500 INR
24-Dec-2025 05:02 GMT
Finalize My Concept Logo Category: Adobe Illustrator, Branding, CorelDRAW, Graphic Design, Illustration, Logo Design, Photoshop, Vector Design Budget: $15 - $25 USD
24-Dec-2025 05:02 GMT
Personal Tech Troubleshooting Help Category: Computer Repair, Computer Support, Performance Tuning, System Administration, System Analysis, Technical Documentation, Technical Support, Troubleshooting Budget: ₹12500 - ₹37500 INR