Build Excel Template to Extract from Source Sheet (No Macros)

I need an Excel template that allows automatic extraction of Index and Population data from a pasted dataset. The source data will always follow the same format but may vary in size (rows/columns). Multiple sample datasets will be provided for testing.

Requirements:
• A “Raw Data” sheet where the user pastes new source data each time
• One or two extraction sheets:
• Option A: A single extraction sheet with filters (preferred) showing both Index and Population for ease of analysis
• Option B: Two separate extraction sheets — one for Index, one for Population — if filtering becomes difficult in a combined view
• The extraction sheet(s) should update automatically upon pasting new data in the source
• Must handle moderate variation in row and column counts
• No macros or VBA
• Use standard Excel tools only (e.g., formulas, pivot tables, filters)
• Layout must be clean, user-friendly, and easy to read

Sample datasets will be provided to test accuracy and adaptability.