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.
Turbojet Engine SolidWorks Model Category: 3D CAD, 3D Design, 3D Modelling, 3D Rendering, Manufacturing Design, Mechanical Engineering, Product Design, Solidworks Budget: ₹1500 - ₹12500 INR
20-Nov-2025 23:02 GMT
Android App with Google Sheets Sync Category: Android, API Integration, App Development, Database Management, Excel, Java, Kotlin, Mobile App Development Budget: ₹1500 - ₹12500 INR
20-Nov-2025 23:01 GMT
Brand Design Category: Branding, Graphic Design, Logo Design, Social Media Marketing Budget: £20 - £250 GBP
Ecommerce para tours de agencia Category: Content Management System (CMS), Payment Gateway Integration, Payment Processing, SEO, Shopify, Web Design, Web Development, WooCommerce Budget: $30 - $250 USD
Edición de video Category: Adobe Premiere Pro, After Effects, Animation, Camtasia, Final Cut Pro, Podcast Editing, Video Editing, Video Post Editing, Video Production, Video Services Budget: $30 - $250 USD
20-Nov-2025 22:50 GMT
SEO Restoran Tingkatkan Visibilitas Category: Content Writing, Digital Marketing, Google Adwords, Google Analytics, Internet Marketing, Keyword Research, Link Building, SEO Budget: $15 - $25 USD