Auto Import Specified Data from one sheet t another

[RedPed]

Hi,

I would like to accomplish the following;

Workbook1

<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 0"]
<colgroup><col style="width: 100px"><col width="113"><col width="100"></colgroup><tbody>[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=B7B7B7]#B7B7B7[/URL] , align: center"]Meal[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=B7B7B7]#B7B7B7[/URL] , align: center"]Food[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=B7B7B7]#B7B7B7[/URL] , align: center"]Calories[/TD]
[/TR]
[TR]
[TD="align: center"]Breakfast[/TD]
[TD="align: center"]Bacon[/TD]
[TD="align: center"]250[/TD]
[/TR]
[TR]
[TD="align: center"]Breakfast[/TD]
[TD="align: center"]Eggs[/TD]
[TD="align: center"]70[/TD]
[/TR]
[TR]
[TD="align: center"]Lunch[/TD]
[TD="align: center"]Sandwich[/TD]
[TD="align: center"]125[/TD]
[/TR]
[TR]
[TD="align: center"]Dinner[/TD]
[TD="align: center"]Pizza[/TD]
[TD="align: center"]600[/TD]
[/TR]
[TR]
[TD="align: center"]Tea[/TD]
[TD="align: center"]Pasta Bolognese[/TD]
[TD="align: center"]400[/TD]
[/TR]
[TR]
[TD="align: center"]Tea[/TD]
[TD="align: center"]Roast Chicken[/TD]
[TD="align: center"]350[/TD]
[/TR]
[TR]
[TD="align: center"]Lunch[/TD]
[TD="align: center"]Soup[/TD]
[TD="align: center"]75[/TD]
[/TR]
[TR]
[TD="align: center"]Breakfast[/TD]
[TD="align: center"]Toast[/TD]
[TD="align: center"]25[/TD]
[/TR]
[TR]
[TD="align: center"]Snacks[/TD]
[TD="align: center"]Chocolate[/TD]
[TD="align: center"]150[/TD]
[/TR]
</tbody>[/TABLE]


For a totally different workbook I wish to import all row data where Meal Column = Breakfast. I would also like the different workbook data to be updated when changes are made to original workbook?

Is this possible?

Any help appreciated