Microsoft Copilot Notebook Q-and-A: Multi-Source Answer Composition

You have multiple documents, emails, or meeting transcripts and need Copilot in Microsoft 365 to synthesize a single, coherent answer from all of them. The Notebook feature in Copilot allows you to paste or reference up to several sources of text and then compose an answer that draws from each source. This article explains how Notebook works for multi-source answer composition, the technical process behind it, and the exact steps to set up your own multi-source Q-and-A session.

How Notebook Composes Answers from Multiple Sources

Notebook is a dedicated workspace inside Copilot for Microsoft 365. Unlike the chat pane, which relies on your Microsoft Graph data and the current document context, Notebook lets you manually define the full set of input texts. When you add multiple sources, Copilot treats them as a single context window. It processes each source separately, extracts relevant passages, and then combines those passages into a unified answer. The model does not average the sources. Instead, it identifies the most relevant information from each source and composes a response that respects the order and logical flow of your question.

The underlying technology uses a retrieval-augmented generation approach. Copilot first retrieves candidate passages from each source based on semantic similarity to your query. It then ranks and merges those passages, removing duplicates and resolving contradictions by preferring the most recent or most authoritative source. Finally, the language model generates the answer using the merged passages as context. The result is a single answer that may reference multiple sources in different sentences or even within the same sentence.

Prerequisites for using Notebook with multiple sources:

• A Microsoft 365 subscription that includes Copilot for Microsoft 365.
• Access to the Copilot pane in Microsoft Teams, Word, or the Copilot web app.
• At least two text sources. Each source can be a document, an email, a meeting transcript, or a plain text paste.
• Sources must be in a supported format: .docx, .pdf, .txt, .eml, or pasted plain text. Maximum 20 sources per session.

Steps to Create a Multi-Source Q-and-A Session in Notebook

Method 1: Paste Sources Directly into Notebook

1. Open the Copilot Notebook
   In Microsoft Teams, click the Copilot icon in the left sidebar. In the Copilot pane, select the Notebook tab. If you are in Word, open the Copilot pane from the Home tab and click Notebook.
2. Add your first source
   Click the Add source button in the top toolbar. Choose Paste text. Paste the full content of your first document, email, or transcript. Give the source a name such as Source 1: Q3 Report.
3. Add additional sources
   Repeat step 2 for each additional source. You can also upload files by clicking Add source and selecting Upload file. Supported file types include .docx, .pdf, .txt, and .eml. You can add up to 20 sources.
4. Type your question
   In the text input area at the bottom of the Notebook pane, type a question that requires information from multiple sources. For example: Compare the revenue figures from Source 1 and Source 2 and summarize the key differences.
5. Review the composed answer
   Copilot generates a response. Each sentence or claim that came from a specific source includes a numbered citation in brackets. Click the citation number to see the exact passage from the source.
6. Refine the answer if needed
   If the answer does not cover all sources equally, type a follow-up instruction such as: Add details from Source 4 about the marketing spend. Copilot updates the answer to include that source.

Method 2: Reference Microsoft Graph Files in Notebook

1. Open Notebook and sign in
   In the Copilot pane, click Notebook. Ensure you are signed in with your work or school account that has Copilot for Microsoft 365.
2. Click Add source and choose From files
   Select From files. A file picker shows your recent documents from OneDrive and SharePoint. Select one file. Copilot reads the file content and adds it as a source.
3. Add more files or paste text
   Repeat step 2 for each file. You can mix file references and pasted text sources. The Notebook pane displays all sources in a list.
4. Ask a cross-source question
   Type a question that draws from multiple files. For example: What were the main action items from the last three team meeting transcripts?
5. Verify source attribution
   Each part of the answer includes a source tag. Hover over the tag to see the file name and the specific excerpt used.

Common Mistakes and Limitations with Multi-Source Answers

Copilot returns an answer that only uses one source

This happens when your question is too narrow. For example, asking What was the exact revenue in Q3? will likely pull from only one source if that source contains the exact figure. To force multi-source composition, rephrase your question to explicitly request comparison or synthesis. Use phrases like Compare the revenue figures from all sources or List the different projections mentioned across the documents.

The answer contains conflicting information from different sources

Copilot does not resolve contradictions automatically. If Source A says the budget is $50,000 and Source B says $55,000, the answer may include both numbers without a reconciliation. In this case, use a follow-up instruction: Resolve the budget discrepancy by checking the most recent source. Copilot will then prioritize the source with the later date or ask you to specify a preferred source.

Source limit is reached but more sources are needed

Notebook allows a maximum of 20 sources per session. If you need more, split your analysis into multiple Notebook sessions. For example, first analyze sources 1-10 and summarize key points. Then start a new Notebook session with sources 11-20 and the summary from the first session as one of the sources.

Attribution numbers are missing from the answer

If you paste text that does not include a source name, Copilot may still generate citations but they will appear as Source 1, Source 2, and so on. To get meaningful attribution, always name each source when you paste it. Click the source name field and enter a descriptive label such as Q3 Financial Report or Email from Marketing Team.

Copilot Notebook vs Copilot Chat for Multi-Source Answers

Item	Copilot Notebook	Copilot Chat
Source input method	Manual paste or file upload up to 20 sources	Automatic retrieval from Microsoft Graph and current document
Source control	Full control over which sources are included	Limited to what Copilot finds relevant
Attribution visibility	Numbered citations with clickable source excerpts	Inline file names with hover preview
Best use case	Comparing specific documents or transcripts	Quick answers from your Microsoft 365 data
Session persistence	Sources remain until you close the Notebook tab	Conversation history only

Copilot Notebook is the stronger choice when you need precise control over the input text and explicit source attribution. Use Copilot Chat when you want a fast answer without manually defining sources.

You can now compose multi-source answers in Copilot Notebook by pasting or uploading up to 20 text sources and asking comparative or synthesis questions. The numbered citation system lets you verify each part of the answer against its original source. For your next project, try the refine feature with the command “summarize using only sources 5 through 8” to narrow the scope without losing the multi-source benefit.