I have a spreadsheet with multiple sheets.

Sheet1 Column A has alpha numeric values in it like M1, M2, M3, etc. along with empty cells between them. There may be duplicates but that doesn't matter.

I need a formula that I can put on Sheet2 that will generate a consolidated list of what is on Sheet1 based on certain criteria.

For Example:

SHEET1

A | B | C | |

1 | M1 | 2 | Twigs |

2 | M1 | 1 | Berries |

3 | |||

4 | M2 | 3 | Twigs |

5 |

<tbody>

</tbody>

I need the formula to look in Column A on Sheet1 and find all the rows that have a value starting with the letter "M", and then return the values Sheet 1 Columns B & C, but consolidated as shown here.

A | B | |

1 | Twigs | 5 |

2 | Berries | 1 |

3 | ||

4 | ||

5 |

<tbody>

</tbody>

Thank you,

B