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.
Facebook Ad Video Editing Category: A / V Editing, Adobe Premiere Pro, After Effects, Facebook Ads, Facebook Marketing, Graphic Design, Video Ads, Video Editing, Video Production, Video Services Budget: $30 - $250 USD
Full-Time Video Editor Needed Category: Adobe Premiere Pro, After Effects, Content Creation, Motion Graphics, Social Media Marketing, Video Editing, Video Services, Videography Budget: ₹12500 - ₹37500 INR
13-Feb-2026 05:01 GMT
Entri Data Foto ke Excel Category: Data Analysis, Data Cleansing, Data Entry, Data Management, Data Processing, Excel, Typing, Web Search Budget: $8 - $15 USD
AI Document Extraction & Dashboard Category: Analytics, API Development, Data Extraction, Data Visualization, Database Management, Full Stack Development, NLP, OCR, Web Development Budget: €1500 - €3000 EUR