Hello, I need to search my excel spreadsheet for a char value, then when this value is found I have to concatenate the 5 columns after this char, Once i have all this data I want to put it in another sheet in a specific spot.

ex take a1-a5 in sheet one and put it in to a5-a10 in sheet 2

MY problem is that different characters have different amounts of following columns

for instance if i search for A i need a1-a5
if i search for B i need a10-a20

Anybody have any advice
thanks!!