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.
Turnitin AI Detection Report Category: Academic Writing, AI Chatbot Development, AI Research, AI Text To Text, Editing, Proofreading, Research Writing, Technical Writing Budget: $10 - $30 USD
03-Apr-2026 10:04 GMT
Toko website Category: CPanel, ECommerce, Graphic Design, HTML, Payment Gateway Integration, PHP, SEO, Web Development, Web Design Budget: $15 - $25 USD
Video Editor for social media Category: After Effects, Color Grading, Social Media Marketing, Video Ads, Video Editing, Video Production, Video Services, Videography Budget: ₹100 - ₹400 INR
Python Email Sender with Personalization Category: API Integration, Email Marketing, Excel, Linux, Microsoft Outlook, OAuth, PHP, Python, Software Architecture Budget: $10 - $30 USD
03-Apr-2026 09:54 GMT
Paid Ads Manager for Automotive Parts Company Category: Advertising, Conversion Rate Optimization, Digital Marketing, ECommerce, Google Ads, Google Adwords, Internet Marketing, Lead Generation, Marketing Strategy, SEO Budget: $30 - $80 USD
03-Apr-2026 09:54 GMT
Dynamic Apache Airflow DAGs Category: Amazon Web Services, CI / CD, Data Governance, Data Integration, Data Processing, Debugging, Linux, Redshift, Snowflake, Terraform Budget: ₹750 - ₹1250 INR
