Need to populate data from main sheet

[Ahmed Fawad]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Department[/TD]
[TD]POST[/TD]
[TD]Name[/TD]
[TD]Email[/TD]
[TD]Contact[/TD]
[TD]City[/TD]
[TD]Remarks[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Admin[/TD]
[TD]Clerk[/TD]
[TD]abc[/TD]
[TD]abc@abc.com[/TD]
[TD]04334325[/TD]
[TD]Dubai[/TD]
[TD]Free for job[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Sales[/TD]
[TD]BDE[/TD]
[TD]xyz[/TD]
[TD]xyz@dfdas.com[/TD]
[TD]89478943[/TD]
[TD]Al Ain[/TD]
[TD]on Job[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I got this data sheet, on the next sheet i want to select post from this data to populate all data in multiple lines which has that post mentioned.

any help will be highly appreciated.

Thanks